mysql 关联表修改数据

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='[]'

posted @ 2018-10-29 10:22  懒人写博客  阅读(848)  评论(0)  编辑  收藏  举报