update table1,table2 set
table1.cloumn1= table2.cloumn2
where table1.cloumn5= table2.cloumn6
update table1,table2 set
table1.cloumn1= table2.cloumn2
where table1.cloumn5= table2.cloumn6
转载于:https://my.oschina.net/2892328252/blog/870991