mysql笔记-[Err] 1235 - This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
这个错误的出现是由于,在子查询里面用了limit所导致的,如下是错误的做法:select * from table where type in
(select type from table group by type order by count(*) desc limit 3)要解决这个问题,只要子查询里面再套一层就可以了,如下:select * from table where typ
原创
2017-06-02 10:09:25 ·
2422 阅读 ·
0 评论