iteye_12116的博客

原创 This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME 错误解决

MySQL5.1中子查询是不能使用LIMIT的， 会报错： “This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ ” 比如这样的语句是不能正确执行的。 select * from table where id in (select id from table limit 12)...