|
查詢前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;
|
|
|
來自： pengx > 《MySQL/Oracle》
