测试.sql

来自「用户名：liuxinrui 密码：zhongyong 您可以在 linu」· SQL 代码 · 共 20 行

insert into Product values('pen','zhi',50)
insert into Product values('clock','ge',30)
insert into Product values('apple','kg',100)

insert into Supplier values('0001','A_Co','changsha','0731-8800666',1)
insert into Supplier values('0002','B_Co','beijing','010-87654321',1)

insert into Supplier values('0003','C_Co','guangzhou','020-12345678',2)

insert into Trade values('in','2005-01-01','A_Co','0731-8800666',1,5,100,500)
insert into Trade values('out','2005-01-02','B_Pr','0731-2352491',1,5,-20,-100)
insert into Trade values('out','2005-01-02','B_Pr','0731-2352491',1,5,-20,-100)
insert into Trade values('out','2005-01-02','B_Pr','0731-2352491',1,5,-20,-100)


insert into Trade values('in','2005-01-01','C_Co','020-12345678',2,50,50,2500)
insert into Trade values('out','2005-01-02','B_Pr','0731-2352491',2,50,-10,-500)