This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

最新推荐文章于 2022-07-06 15:00:07 发布

iteye_17476

最新推荐文章于 2022-07-06 15:00:07 发布

阅读量138

点赞数

分类专栏：数据库 java 蕃薯耀分享文章标签： MySQL MySQL子查询蕃薯耀蕃薯 This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

蕃薯耀分享同时被 3 个专栏收录

205 篇文章

订阅专栏

java

112 篇文章

订阅专栏

数据库

18 篇文章

订阅专栏

【mysql错误】 This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

SELECT * FROM duona_business_cash_ticket ct WHERE ct.id IN (  SELECT cr.id FROM duona_user_consume_record cr ORDER BY cr.createTime DESC LIMIT 3) LIMIT 3

解决方法：

SELECT * FROM duona_business_cash_ticket ct WHERE ct.id IN ( SELECT t.id FROM (SELECT cr.id FROM duona_user_consume_record cr ORDER BY cr.createTime DESC LIMIT 3) AS t ) LIMIT 3

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

蕃薯耀 2012年12月18日 16:41:35 星期二