update left join 多表关联更新

UPDATE table_1 t1 
left join table_2 t2 on t2.id = t1.id
SET t1.userName = t2.name,t1.userAge=t2.age
where t1.id>5;