1-4.sql

数据库的开发事例

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)