Mysql的update-left join-where的联合使用 UPDATE sys_user a left join sys_dept b on a.dept_id = b.id left join sys_role_user c on c.user_id = a.id set a.base = 6 where b.full_name like 'aaaaaa%' and c.user_id is not null