嵌套查询,in里层有序的主键,查询出的数据没有按照主键排序

这跟版本没关系吧,select * from t1 where id in (select id from t1 where id > 432100 order by t1_id asc limit 4000);你这个sql后面是不是应该再排下序就行了。select * from t1 where id in (select id from t1 where id > 432100 order by t1_id asc limit 4000) order by id asc;