UPDATE t1 INNER JOIN t2 ON t1.c1=t2.c1 SET t1.c2=value WHERE t1`removed`=0 AND t2`removed`=0
AND t1.c3='[]'
mysql 关联表修改数据
最新推荐文章于 2023-05-24 13:48:08 发布
UPDATE t1 INNER JOIN t2 ON t1.c1=t2.c1 SET t1.c2=value WHERE t1`removed`=0 AND t2`removed`=0
AND t1.c3='[]'