myslq将一个表的数据更新到另一表中

 update blade_employee_training_record_detail a,blade_employee_training_user_dept b set a.dept_name=b.user_dept  where a.user_name=b.user_name

  

原文地址:https://www.cnblogs.com/xianz666/p/14846727.html