mysql -limit 自增主键

SELECT *,tcs_order_id FROM xxx LIMIT 10 ,1;

SELECT tcs_order_id FROM xxx LIMIT 10 ,1;

尝试后发现 加上 order by 就正常了。

SELECT tcs_order_id FROM xxx ORDER BY tcs_order_id LIMIT 10 ,1;