多字段更新
方式1
update table a set (column01,colum02, column03) = (select b.column01, b.column02,b.column03 from table b where a.column= b.column)
方式2
update table a set column01 = t.column01 , column02 = t.column02 , column03 = t.column03 from table t where a.column04 = t.column04 and a.column05 = t.column05
单字段更新
update table a set column = ( select b.column from table b where a.id = b.id )