把MSSQL换成了MYSQL，一个简单实现分页的SQL语句却总是出错MSSQL：
select top 5 from test where id NOT IN (select top 5 id from test)MYSQL：
select * from test where id NOT IN (select id from test limit 5) limit 5MYSQL5.0 总是提示“This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'”子查询中的limit去掉就正常了，奇怪奇怪
select top 5 from test where id NOT IN (select top 5 id from test)MYSQL：
select * from test where id NOT IN (select id from test limit 5) limit 5MYSQL5.0 总是提示“This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'”子查询中的limit去掉就正常了，奇怪奇怪
select * from test limit 5,5
不就可以了