-- trading_info插入记录7-12
INSERT INTO trading_info VALUES(7,12,1,5);
INSERT INTO trading_info VALUES(8,13,2,30);
INSERT INTO trading_info VALUES(9,14,1,2);
INSERT INTO trading_info VALUES(10,15,2,4);
INSERT INTO trading_info VALUES(11,7,1,4);
INSERT INTO trading_info VALUES(12,9,2,10);
INSERT INTO trading_info VALUES(7,12,1,5);
INSERT INTO trading_info VALUES(8,13,2,30);
INSERT INTO trading_info VALUES(9,14,1,2);
INSERT INTO trading_info VALUES(10,15,2,4);
INSERT INTO trading_info VALUES(11,7,1,4);
INSERT INTO trading_info VALUES(12,9,2,10);
2016-09-14
-- trading_info插入记录1-6
INSERT INTO trading_info VALUES(1,6,1,1);
INSERT INTO trading_info VALUES(2,7,2,3);
INSERT INTO trading_info VALUES(3,8,1,2);
INSERT INTO trading_info VALUES(4,9,2,6);
INSERT INTO trading_info VALUES(5,10,1,8);
INSERT INTO trading_info VALUES(6,11,2,12);
INSERT INTO trading_info VALUES(1,6,1,1);
INSERT INTO trading_info VALUES(2,7,2,3);
INSERT INTO trading_info VALUES(3,8,1,2);
INSERT INTO trading_info VALUES(4,9,2,6);
INSERT INTO trading_info VALUES(5,10,1,8);
INSERT INTO trading_info VALUES(6,11,2,12);
2016-09-14
-- 创建trading_info表
CREATE TABLE IF NOT EXISTS trading_info(
trading_id int not null,
trading_goods_id int not null,
trading_user_id int not null,
trading_number int
);
CREATE TABLE IF NOT EXISTS trading_info(
trading_id int not null,
trading_goods_id int not null,
trading_user_id int not null,
trading_number int
);
2016-09-14
--goods_list添加信息6-10
INSERT INTO goods_list VALUES(13,'助兴pad',900,1700);
INSERT INTO goods_list VALUES(10,'遐想手机',800,1100);
INSERT INTO goods_list VALUES(8,'酷为手机',650,1100);
INSERT INTO goods_list VALUES(12,'助兴手机',900,1600);
INSERT INTO goods_list VALUES(14,'棒槌手机',1300,3100);
INSERT INTO goods_list VALUES(13,'助兴pad',900,1700);
INSERT INTO goods_list VALUES(10,'遐想手机',800,1100);
INSERT INTO goods_list VALUES(8,'酷为手机',650,1100);
INSERT INTO goods_list VALUES(12,'助兴手机',900,1600);
INSERT INTO goods_list VALUES(14,'棒槌手机',1300,3100);
2016-09-14
--goods_list添加信息1-5
INSERT INTO goods_list VALUES(9,'酷为pad',700,1500);
INSERT INTO goods_list VALUES(15,'棒槌pad',1200,3100);
INSERT INTO goods_list VALUES(11,'遐想pad',750,1100);
INSERT INTO goods_list VALUES(6,'华派手机',1200,1800);
INSERT INTO goods_list VALUES(7,'华派pad',800,1400);
INSERT INTO goods_list VALUES(9,'酷为pad',700,1500);
INSERT INTO goods_list VALUES(15,'棒槌pad',1200,3100);
INSERT INTO goods_list VALUES(11,'遐想pad',750,1100);
INSERT INTO goods_list VALUES(6,'华派手机',1200,1800);
INSERT INTO goods_list VALUES(7,'华派pad',800,1400);
2016-09-14
-- Mysql创建goods_list
CREATE TABLE IF NOT EXISTS goods_list(
goods_id INT UNSIGNED,
goods_name VARCHAR(30) NOT NULL,
cost_price INT UNSIGNED NOT NULL DEFAULT 0,
selling_price INT UNSIGNED NOT NULL DEFAULT 0
);
CREATE TABLE IF NOT EXISTS goods_list(
goods_id INT UNSIGNED,
goods_name VARCHAR(30) NOT NULL,
cost_price INT UNSIGNED NOT NULL DEFAULT 0,
selling_price INT UNSIGNED NOT NULL DEFAULT 0
);
2016-09-14