UPDATE tb1,tb2 SET tb1.address=tb2.address WHERE tb1.name=tb2.name
UPDATE
tb1,tb2
SET
tb1.address=tb2.address
WHERE
tb1.
name
=tb2.
mysql 多表关联更新
原文：http://www.cnblogs.com/beanliu/p/4057315.html
