UPDATE table1 t1
LEFT JOIN table2 t2 ON t2.field1 = t1.field1
SET t1.field2 = 4
WHERE …
mysql联表修改
最新推荐文章于 2024-06-11 16:09:08 发布
UPDATE table1 t1
LEFT JOIN table2 t2 ON t2.field1 = t1.field1
SET t1.field2 = 4
WHERE …