MySQL创建仓库表并添加数据示例
CREATE TABLE tab_warehouse (
wid int(11) NOT NULL,
wname varchar(20) DEFAULT NULL,
waddress varchar(20) DEFAULT NULL,
wmoney double DEFAULT NULL,
PRIMARY KEY (wid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
INSERT INTO tab_warehouse (wid, wname, waddress, wmoney) VALUES (1, '仓库1', '地址1', 1000.0);
INSERT INTO tab_warehouse (wid, wname, waddress, wmoney) VALUES (2, '仓库2', '地址2', 2000.0);
INSERT INTO tab_warehouse (wid, wname, waddress, wmoney) VALUES (3, '仓库3', '地址3', 3000.0);
INSERT INTO tab_warehouse (wid, wname, waddress, wmoney) VALUES (4, '仓库4', '地址4', 4000.0);
INSERT INTO tab_warehouse (wid, wname, waddress, wmoney) VALUES (5, '仓库5', '地址5', 5000.0);
原文地址: https://www.cveoy.top/t/topic/qp2R 著作权归作者所有。请勿转载和采集!