1-4.sql

来自「数据库的开发事例」· SQL 代码 · 共 33 行

insert into 订单明细表 values ('20051001',1,'PR200501',10)
insert into 订单明细表 values ('20051001',2,'PR200502',100)
insert into 订单明细表 values ('20051002',3,'PR200501',10)
insert into 订单明细表 values ('20051002',4,'PR200503',200)
insert into 订单明细表 values ('20051003',5,'PR200505',5)
insert into 订单明细表 values ('20051003',6,'PR200508',1000)
insert into 订单明细表 values ('20051004',7,'PR200501',20)
insert into 订单明细表 values ('20051004',8,'PR200507',500)
insert into 订单明细表 values ('20051005',9,'PR200510',1000)
insert into 订单明细表 values ('20051005',10,'PR200502',300)
insert into 订单明细表 values ('20051006',11,'PR200501',50)
insert into 订单明细表 values ('20051006',12,'PR200502',400)
insert into 订单明细表 values ('20051007',13,'PR200501',15)
insert into 订单明细表 values ('20051007',14,'PR200506',160)
insert into 订单明细表 values ('20051008',15,'PR200503',10)
insert into 订单明细表 values ('20051008',16,'PR200509',80)
insert into 订单明细表 values ('20051009',17,'PR200501',60)
insert into 订单明细表 values ('20051009',18,'PR200502',200)
insert into 订单明细表 values ('20051010',19,'PR200507',100)
insert into 订单明细表 values ('20051010',20,'PR200508',100)
insert into 订单明细表 values ('20051011',21,'PR200501',20)
insert into 订单明细表 values ('20051012',22,'PR200509',500)
insert into 订单明细表 values ('20051013',23,'PR200510',1000)
insert into 订单明细表 values ('20051014',24,'PR200506',100)
insert into 订单明细表 values ('20051015',25,'PR200501',10)
insert into 订单明细表 values ('20051016',26,'PR200502',100)
insert into 订单明细表 values ('20051017',27,'PR200503',10)
insert into 订单明细表 values ('20051018',28,'PR200504',100)
insert into 订单明细表 values ('20051019',29,'PR200505',10)
insert into 订单明细表 values ('20051020',30,'PR200504',100)