下面的语句不能正确执行,报错为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 10);
但是,,但是,,,只要你再来一层就行。。如:
select * from table where id in (select t.id from (select * from table limit 10)as t)
你说说,MySQL是不是很让人无语??