-- 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
-- 創(chuàng)建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創(chuàng)建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
強烈建議老師把源碼貼出來啊,畢竟很多細(xì)節(jié)老師沒有重點強調(diào)的地方,正是我們需要花時間自己消化的啊
2016-09-08
強烈建議老師把源碼貼出來啊,畢竟很多細(xì)節(jié)老師沒有重點強調(diào)的地方,正是我們需要花時間自己消化的啊。
2016-09-07