实验实验 31 1、自行设计各个表自行设计各个表INSERT INTO 订货.仓库values (CA0001,那边风景好,100);INSERT INTO 订货.仓库values (CA0002,那边风景1,100);INSERT INTO 订货.仓库values (CA0003,那边风景2,100);INSERT INTO 订货.仓库values (CA0004,那边风景3,100);INSERT INTO 订货.仓库values (CA0005,那边风景4,100);INSERT INTO 订货.仓库values (CA0006,那边风景5,100);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000001,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000002,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000003,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000004,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000005,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000006,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000007,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000008,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0003,BA000009,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0003,BA000010,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0003,BA000011,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA00012,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000013,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000014,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000015,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000016,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000017,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA00018,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000019,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000020,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000021,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA000022,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA000023,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA00024,1500)insert into 订货.供应商values (S001,小李,NULL);insert into 订货.供应商values (S002,小王,NULL);insert into 订货.供应商values (S003,小张,NULL);insert into 订货.供应商values (S004,小李,NULL);insert into 订货.供应商values (S005,小王,NULL);insert into 订货.订购单values (BA000001,S001,OR0001,DEFAULT,NULL,null);insert into 订货.订购单values (BA000002,S001,OR0002,DEFAULT,NULL,null);insert into 订货.订购单values (BA000003,S001,OR0003,DEFAULT,NULL,null);insert into 订货.订购单values (BA000004,S001,OR0004,DEFAULT,NULL,null);insert into 订货.订购单values (BA000005,S002,OR0005,DEFAULT,NULL,null);insert into 订货.订购单values (BA000006,S002,OR0006,DEFAULT,NULL,null);insert into 订货.订购单values (BA000007,S002,OR0007,DEFAULT,NULL,null);insert into 订货.订购单values (BA000008,S003,OR0008,DEFAULT,NULL,null);insert into 订货.订购单values (BA000009,S003,OR0009,DEFAULT,NULL,null);insert into 订货.订购单values (BA000010,S003,OR0010,DEFAULT,NULl,null);insert into 订货.订购单values (BA000011,S004,OR0011,DEFAULT,NULL,null);insert into 订货.订购单values (BA000012,S004,OR0012,DEFAULT,NULl,null);insert into 订货.订购单values (BA000013,S004,OR0013,DEFAULT,NULL,null);insert into 订货.订购单values (BA000014,S005,OR0014,DEFAULT,NULL,null);insert into 订货.订购单values (BA000015,S005,OR0015,DEFAULT,NULL,null);insert into 订货.订购单values (BA000016,S005,OR0016,DEFAULT,NULL,null);insert into 订货.订购单values (BA000017,S005,OR0017,DEFAULT,NULL,null);insert into 订货.订购单values (BA000018,NULL,OR0018,DEFAULT,NULL,null);insert into 订货.订购单values (BA000019,NULL,OR0019,DEFAULT,NULL,null);insert into 订货.订购单values (BA000020,NULL,OR0020,DEFAULT,NULL,null);insert 订货.订购单明细values (OR0001,01,NULL,20,100);insert 订货.订购单明细values (OR0001,02,NULL,20,100);insert 订货.订购单明细values (OR0001,03,NULL,20,100);insert 订货.订购单明细values (OR0002,04,NULL,20,100);insert 订货.订购单明细values (OR0002,05,NULL,20,100);insert 订货.订购单明细values (OR0002,06,NULL,20,100);insert 订货.订购单明细values (OR0002,07,NULL,20,100);insert 订货.订购单明细values (OR0003,08,NULL,20,100);INSERT 订货.订购单明细values (OR0003,09,NULL,20,100);insert 订货.订购单明细values (OR0003,10,NULL,20,100);insert 订货.订购单明细values (OR0004,11,NULL,20,100);insert 订货.订购单明细values (OR0005,12,NULL,20,100);insert 订货.订购单明细values (OR0005,13,NULL,20,100);insert 订货.订购单明细values (OR0005,14,NULL,20,100);insert 订货.订购单明细values (OR0006,15,NULL,20,100);insert 订货.订购单明细values (OR0006,16,NULL,20,100);insert 订货.订购单明细values (OR0007,17,NULL,20,100);insert 订货.订购单明细values (OR0007,18,NULL,20,100);insert 订货.订购单明细values (OR0007,19,NULL,20,100);insert 订货.订购单明细values (OR0007,20,NULL,20,100);insert 订货.订购单明细values (OR0008,21,NULL,20,100);insert 订货.订购单明细values (OR0008,22,NULL,20,100);insert 订货.订购单明细values (OR0009,23,NULL,20,100);insert 订货.订购单明细values (OR0009,24,NULL,20,100);insert 订货.订购单明细values (OR0009,25,NULL,20,100);insert 订货.订购单明细values (OR0010,26,NULL,20,100);insert 订货.订购单明细values (OR0010,27,NULL,20,100);insert 订货.订购单