+
|
←クリックで開く |
create table sales (
id int auto_increment,
date datetime not null,
customer varchar(50) not null,
price int not null,
count int not null,
goods_id int not null,
primary key (id)
);
create table goods (
goods_id int auto_increment,
goods_name varchar(50) not null,
primary key (goods_id)
);
insert into sales values (1, '2007/01/01', '山田産業(株)', 50, 12, 1);
insert into sales values (2, '2007/01/12', '(株)田中商事', 100, 10, 2);
insert into sales values (3, '2007/01/15', '鈴木建設(株)', 50, 24, 1);
insert into sales values (4, '2007/01/25', '山田産業(株)', 150, 10, 3);
insert into sales values (5, '2007/02/03', '鈴木建設(株)', 100, 20, 2);
insert into sales values (6, '2007/02/09', '(株)田中商事', 100, 10, 2);
insert into sales values (7, '2007/02/14', '鈴木建設(株)', 50, 24, 1);
insert into sales values (8, '2007/02/22', '(株)田中商事', 50, 12, 1);
insert into sales values (9, '2007/03/05', '鈴木建設(株)', 150, 15, 3);
insert into sales values (10, '2007/03/12', '山田産業(株)', 150, 10, 3);
insert into goods values (1, '鉛筆');
insert into goods values (2, '消しゴム');
insert into goods values (3, 'ノート');
|