兢任

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