UPDATE user t1
left join dept t2 on t1.dept_id = t2.dept_id
SET t1.dept_name = t2.dept_name ,
t1.valid='Y'
UPDATE user t1
left join dept t2 on t1.dept_id = t2.dept_id
SET t1.dept_name = t2.dept_name ,
t1.valid='Y'

被折叠的 条评论
为什么被折叠?