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 PRIMARY KEY d_gidd_wid KEY d_wid

INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (1, 1, 100, 200, 50);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (2, 1, 150, 250, 100);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (3, 2, 200, 300, 150);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (4, 2, 120, 220, 80);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (5, 3, 180, 280, 130);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (6, 3, 90, 190, 40);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (7, 4, 300, 400, 250);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (8, 4, 250, 350, 200);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (9, 5, 160, 260, 110);
INSERT INTO table_name (d_gid, d_wid, dnumber, dupper, dlower) VALUES (10, 5, 80, 180, 30)