CREATE TABLE tab_deposit d_gid int11 NOT NULL COMMENT 货品表外键 d_wid int11 NOT NULL COMMENT 仓库表外键 dnumber int11 DEFAULT NULL COMMENT 货品存量 dupper int11 DEFAULT NULL dlower int11 DEFAULT NULL PRIMAR
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (1, 1, 100, 200, 50);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (2, 1, 50, 100, 20);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (3, 2, 200, 500, 100);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (4, 2, 150, 300, 80);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (5, 3, 300, 600, 150);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (6, 3, 250, 400, 100);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (7, 4, 400, 800, 200);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (8, 4, 350, 700, 180);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (9, 5, 500, 1000, 250);
INSERT INTO tab_deposit (d_gid, d_wid, dnumber, dupper, dlower) VALUES (10, 5, 450, 900, 220)
原文地址: http://www.cveoy.top/t/topic/iJLw 著作权归作者所有。请勿转载和采集!