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='[]'
转载于:https://www.cnblogs.com/zqr99/p/9869167.html
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='[]'
转载于:https://www.cnblogs.com/zqr99/p/9869167.html