– 通过子查询关联更新
UPDATE test1 t1 SET t1.name
=(SELECT t2.name FROM test2 t2 WHERE t2.id=t1.id)
– 通过并列连接更新
UPDATE test1 t1 ,test2 t2 SET t1.name=t2.name WHERE t1.id
=t2.id;
– 使用内连接更新
UPDATE test1 t1 INNER JOIN test2 t2 ON t1.id=t2.id SET t2.name=t1.name