SELECT g.goods_id AS goodsId, g.goods_name AS goodsName, SUM(t.trading_number) AS tradingNumber,
COUNT(t.trading_id) AS times, g.selling_price AS sellingPrice, g.cost_price AS costPrice
FROM goods_list g
LEFT JOIN trading_info t ON(t.trading_goods_id = g.goods_id)
GROUP BY g.goods_id
COUNT(t.trading_id) AS times, g.selling_price AS sellingPrice, g.cost_price AS costPrice
FROM goods_list g
LEFT JOIN trading_info t ON(t.trading_goods_id = g.goods_id)
GROUP BY g.goods_id
2018-01-16
CREATE TABLE buyer(
userid VARCHAR(20) NOT NULL COMMENT'買家ID',
name VARCHAR(20) NOT NULL COMMENT '買家姓名',
age INT(3) DEFAULT NULL COMMENT '買家年齡',
sex VARCHAR(2) DEFAULT NULL COMMENT '買家性別',
area VARCHAR(30) DEFAULT NULL COMMENT '買家所在地區(qū)',
tel INT(16) DEFAULT NULL COMMENT '買家電話');
userid VARCHAR(20) NOT NULL COMMENT'買家ID',
name VARCHAR(20) NOT NULL COMMENT '買家姓名',
age INT(3) DEFAULT NULL COMMENT '買家年齡',
sex VARCHAR(2) DEFAULT NULL COMMENT '買家性別',
area VARCHAR(30) DEFAULT NULL COMMENT '買家所在地區(qū)',
tel INT(16) DEFAULT NULL COMMENT '買家電話');
CREATE TABLE goods(
goods_id VARCHAR(255) NOT NULL COMMENT'商品ID',
goods_name VARCHAR(255) DEFAULT NULL COMMENT '商品名稱',
cost_price DOUBLE DEFAULT NULL COMMENT '成本價',
selling_price DOUBLE DEFAULT NULL COMMENT '售價',
manufacturer VARCHAR(255) DEFAULT NULL COMMENT '制造商');
goods_id VARCHAR(255) NOT NULL COMMENT'商品ID',
goods_name VARCHAR(255) DEFAULT NULL COMMENT '商品名稱',
cost_price DOUBLE DEFAULT NULL COMMENT '成本價',
selling_price DOUBLE DEFAULT NULL COMMENT '售價',
manufacturer VARCHAR(255) DEFAULT NULL COMMENT '制造商');
好評,真的,不要太專注老師寫的那個sql邏輯,,主要看功能,反正我是學到了,說最low的那個人,應該沒有禮貌,或者和老師有仇,或者零基礎看不懂!
2017-12-11