查詢前n條記錄:select × from 【table-name】 order by id limit n;
查詢后n條記錄:select * from [ table-name ] order by id desc limit n;
查詢第m條記錄后的n條記錄:select * from [ table-name ] order by id m,n;
|
|
來(lái)自: pengx > 《MySQL/Oracle》