1.单个字段
update table1 set table1.column = (select table2.column from table2 where table1.id = table2.id) where
2.多个字段
update table1 set (table1.column1,table1.coumn2,...) = (select table2.column1,table2.column2,... from table2 where table1.id = table2.id) where
原文：http://www.cnblogs.com/jingrendaxue/p/4974294.html