#子查询(不支持)
update question q set q.`level`=2 where q.id in( select id from question where id>=2111 limit 165,165);
#改写
update question q inner join ( select id from question where id>=2111 limit 165,165) t on q.id=t.id set q.`level`=2;
#子查询(不支持)
delete from `user` where id in (
select min(id) as id from `user` group by wx_open_id having count(1)>1
);
#改写
delete from `user` where id in (
select id from(
select min(id) as id from `user` group by wx_open_id having count(1)>1
) t
);
01-19
500
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-13
674
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-09
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交