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
myslq将一个表的数据更新到另一表中
原文:https://www.cnblogs.com/xianz666/p/14846727.html