mysql多表关联update修改操作

 
UPDATE province_yunnan_salary s1
JOIN province_guangdong_salary s2
ON s1.user_name= s2.user_name
SET s1.salary= s2.salary
WHERE s1.user_name = '周一一'

 

posted @ 2018-11-23 15:43  理舞  阅读(7354)  评论(0)    收藏  举报