商品信息表
订单表
修改 订单表 id = 1的 price为商品表id =1 的price
UPDATE order
SET price=(SELECT price from goods WHERE id =1) WHERE id = 1
查询订单表的每个用户各子消费了多少钱
SELECT username,SUM(goods_num * price)from order
GROUP BY username
商品信息表
订单表
修改 订单表 id = 1的 price为商品表id =1 的price
UPDATE order
SET price=(SELECT price from goods WHERE id =1) WHERE id = 1
查询订单表的每个用户各子消费了多少钱
SELECT username,SUM(goods_num * price)from order
GROUP BY username