问题:MySQL doesn't yet support 'LIMIT & IN/ALL/AN Y/SOME subquery
来源:互联网 发布:怎么开启内网端口 编辑:程序博客网 时间:2024/06/05 02:00
MySQL中子查询是不能使用LIMIT 会报错: “This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ ”
SQL语句应该这样写(红色子所示),即在包装一层,避开limit关键字
String sql = "select p.id,p.product_name,p.description,p.add_time," +
"p.fixed_price,p.dang_price,p. product_pic,b.author,b.publishing," +
"b.publish_time,b.word_number,b.which_edtion,b.total_page," +
"b.isbn from d_d_book b inner join d_d_product p on b.id = p.id " +
"where p.id in (select t.product_id from (select product_id from d_d_item group by product_id " +
"order by count(product_id) limit 3) as t)";
不应该
String sql = "select p.id,p.product_name,p.description,p.add_time," +
"p.fixed_price,p.dang_price,p. product_pic,b.author,b.publishing," +
"b.publish_time,b.word_number,b.which_edtion,b.total_page," +
"b.isbn from d_d_book b inner join d_d_product p on b.id = p.id " +
"where p.id in (select product_id from d_d_item group by product_id " +
"order by count(product_id) limit 3)";
- 问题:MySQL doesn't yet support 'LIMIT & IN/ALL/AN Y/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' 错误解决
- 多层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' 错误解决
- SQL Error (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'
- 快速排序 有问题
- 温家宝:今后5年有3件事情重大而迫切
- Objective-C中的定时器功能
- 我的安卓学习之路--split,StringTokenizer
- 基于Hadoop平台的云存储应用实践
- 问题:MySQL doesn't yet support 'LIMIT & IN/ALL/AN Y/SOME subquery
- C++第11周项目2(8)参考——软件比拼
- 修改论文格式——word技巧大乱斗
- 教授如何骗自己
- 胡锦涛:扭转生态环境恶化趋势建设美丽中国
- 数组中最小没出现的整数
- 同济大学软件学院院长谈择业—关于嵌入式方向
- Android应用开发揭秘的第12个程序5_7_drawImage修改版和高仿版的源码注释
- 用hadoop中的libhdfs和fuse-dfs构建快速云存储(出自 实践检验真理 博客)