【mysql嵌套查询更新】

update store s
join (select store_id,count(*)as count from `order` GROUP BY store_id) tb
on s.id=tb.store_id
set finish_nums = tb.count;