UPDATE wx_archives t1 ,unitinfo_shi t2 SET t1.centercode =t2.centercode ,t1.unitcode =t2.unitcode WHERE t1.company=t2.unitname
博客列表 >mysql更新表中字段到另一个表
UPDATE wx_archives t1 ,unitinfo_shi t2 SET t1.centercode =t2.centercode ,t1.unitcode =t2.unitcode WHERE t1.company=t2.unitname