mysql 多表关联更新

mysql5.5

格式 update table1 t1 inner join table2 t2 on t1.xxx=t2.xxx set t1.xxx=t2.xxx

# 先聚合再更新

update hy_shoppe s2 INNER JOIN 

#聚合结果作为中间表

(select s.name as name, of.shoppe as shoppe, sum(price) as amount from hy_order_form of join hy_shoppe s on of.shoppe=s.id group by of.shoppe, s.name) as temp 

on s2.id=temp.shoppe set s2.amount=temp.amount