update table1 t1 ,table2 t2 set t1.field1 = t2.field2 where t1.id = t2.id 转载于:https://www.cnblogs.com/52php/p/5677908.html