mysql 不支持in/all/any/some 里的limit查询。
比如要在in查询语句中查询select * from table where id not in(select id form table limit 10) , 就会出现如标题中的报错。
换种写法就可以了
select * from table where id not in (select id from (select * from ebay_goods limit 10 ) as t)
例如我想查询 tt_goods 表中 字段type=1 , 非前10条的数据
这样写就可以了
select * from tt_goods where id not in (select t.id from (select * from tt_goods where type = 1 limit 10) as t) where type =1