update som_order soh
set soh.amount =
(select sum(amount)
from som_order_detail b
where soh.keyid = b.order_id),
soh.quantity = (select sum(quantity) from som_order_detail b
where soh.keyid = b.order_id ),
soh.piece = (select sum(piece) from som_order_detail b
where soh.keyid = b.order_id )
where soh.keyid = '5C7BB79D-3782-4C0B-8FAF-7EB3D53BB1CD';
set soh.amount =
(select sum(amount)
from som_order_detail b
where soh.keyid = b.order_id),
soh.quantity = (select sum(quantity) from som_order_detail b
where soh.keyid = b.order_id ),
soh.piece = (select sum(piece) from som_order_detail b
where soh.keyid = b.order_id )
where soh.keyid = '5C7BB79D-3782-4C0B-8FAF-7EB3D53BB1CD';
为什么汇总不是insert
而是update,
以往的数据不要?