原来update还可以这么用，一切都是这么神奇。

update sys_user_info a left join union_menber_info b on a.user_cardno = b.member_cardno

set a.user_state = 0,a.user_level = 1,a.union_id = b.union_id,a.union_name = b.union_name,a.user_pro_cno = b.member_pro_cno,a.member_id = b.member_id

where a.union_id = 1

 

未知工会数据迁移使用的

转载于:https://www.cnblogs.com/taiyanhong/p/6944635.html