UPDATE tableA a
LEFT JOIN tableB b ON a.seller_id = b.seller_id
SET a.active_status = 3
WHERE
a.active_status = 2
AND ...
MySql update left join 关联多张表更新数据
最新推荐文章于 2022-12-20 14:56:02 发布
UPDATE tableA a
LEFT JOIN tableB b ON a.seller_id = b.seller_id
SET a.active_status = 3
WHERE
a.active_status = 2
AND ...