Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
来源:互联网 发布:linux kernel devel 编辑:程序博客网 时间:2024/05/29 03:11
最近遇到一个需要在in里面写limit子查询的情况,然后执行SQL的时候就遇到这个错误:
Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery',
比如查询是:
select * from owner_ship where owner_id in (select id from user limit 4);
MySQL不支持在IN里面有limit,解决办法是再多嵌套一重子查询:
select * from owner_ship where owner_id in (select id from (select id from user limit 4)t);
虽然性能上又差了一点,但是至少解决了目前的问题,应该比增加SQL的数量要好一些。
0 0
- Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- mysql error This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- [Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决
- SQL Error (1235): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
- 多层limit查询 mysql出现异常This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- Mysql:This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决
- 欢迎使用CSDN-markdown编辑器
- 第三方支付
- 使用腾讯云建一个基于自己域名的网站
- 图片验证码的制作
- 正则表达式介绍与使用
- Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
- 【后台开发与系统运维】 Nginx 的反向代理与负载均衡
- 【u104】组合数
- 地图
- JavaScript趣题:找出凶手
- 【学习Linux】break 和continue
- Lucene全文检索初识
- 【git中文教程】GIT使用教程与基本原理
- 《程序员必读软件架构 Part5 为软件生成文档》