-
mysql联表聚合更新
运行下列sql更新查询即可实现提问中的需求:update order,(select order_id,sum(goods_num*goods_price) as m from order_goods group by order_id)
-
mysql联表聚合更新
运行下列sql更新查询即可实现提问中的需求:update order,(select order_id,sum(goods_num*goods_price) as m from order_goods group by order_id)