mysql update select 从查询结果中更新数据

时间：2020-06-26 20:48:04 收藏：0 阅读：473

示例场景

两个表 ordrs, sum_orders， sum_orders 中的count是 orders中相同project_id的count之和；cost同理

一条语句直接更新sum_orders中的count & cost

#orders

技术分享图片

#sum_orders

技术分享图片

示例代码

UPDATE sum_orders a
INNER JOIN ( SELECT project_id, sum( count ) AS sum_count, sum( cost ) AS sum_cost FROM orders GROUP BY project_id ) b ON a.project_id = b.project_id 
SET a.count = b.sum_count,
a.cost = b.sum_cost;

原文：https://www.cnblogs.com/kaituorensheng/p/13196164.html