mysql边查边更新(级联使用)

update law_zlaw as a inner join (select count(v_id) as sum,z_id from law_vsion GROUP BY z_id) as b  on a.z_id=b.z_id set  count_zid = b.sum 

posted @ 2020-05-18 10:42  大梦千年  阅读(394)  评论(0编辑  收藏  举报