select auto,text from tablea order by auto asc limit 1,8orselect a.auto,a.text from tablea a left join (select auto from tablea order by auto asc limit 1) b on a.auto=b.auto where b.auto is null order by auto asc limit 8;
你试试这样:select auto,text from tablea order by auto asc limit 8,2;
SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
left join
(select auto from tablea order by auto asc limit 1) b
on a.auto=b.auto
where b.auto is null order by auto asc limit 8;