CREATE TABLE tab_warehouse wid int11 NOT NULL wname varchar20 DEFAULT NULL waddress varchar20 DEFAULT NULL wmoney double DEFAULT NULL PRIMARY KEY wid ENGINE=InnoDB DEFAULT CHARSET=utf8添加一些生成5个my

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)