update table_1 t1 set t1.name=(select t2.name from table_2 where t1.id=t2.id)

update table_1 t1 sett1.name=(select t2.name from table_2  t2 where t1.id=t2.id)

转载于:https://blog.51cto.com/6817977/1653991