【MySQL】UPDATE LEFT JOIN

UPDATE table_1 t1 
LEFT JOIN table_2 t2 on t2.t1_id = t1.id 
SET t1.t2_name = t2.name, t1.t2_age=t2.age
where t1.t1_id is not null;