怎样将编码code相同的两条数据,字段new_warehouse_num 与 old_warehouse_num的值相加得到总和sum
7条回答 默认 最新
- 社区专家-Monster-XH 2023-04-21 15:08关注
UPDATE table_name t1 JOIN ( SELECT code, SUM(new_warehouse_num + old_warehouse_num) AS total_sum FROM table_name GROUP BY code ) t2 ON t1.code = t2.code SET t1.sum = t2.total_sum;
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 1无用