update table1,table2 set table1.column1 = table2.column2
where table1.column2 = table2.column3
解释:
表一和表二通过table1.column2 = table2.column3关联
批量更新table1.column1 = table2.column2
update table1,table2 set table1.column1 = table2.column2
where table1.column2 = table2.column3
解释:
表一和表二通过table1.column2 = table2.column3关联
批量更新table1.column1 = table2.column2