UPDATE table1 join table2 on table1.字段1=table2.字段2 and table1.字段2!=table2.字段2 and table1.字段3 in (
xxx,
yyy,
zzz
)
set table1.字段2=table2.字段2;
表关联进行更新操作
最新推荐文章于 2024-08-13 16:01:31 发布
UPDATE table1 join table2 on table1.字段1=table2.字段2 and table1.字段2!=table2.字段2 and table1.字段3 in (
xxx,
yyy,
zzz
)
set table1.字段2=table2.字段2;