update table1 t1 ,table2 t2 set t1.field1 = t2.field2 where t1.id = t2.id
MySQL 关联表批量修改(数据同步)
最新推荐文章于 2023-02-01 19:28:28 发布
update table1 t1 ,table2 t2 set t1.field1 = t2.field2 where t1.id = t2.id