LIMIT Query Optimization

 

 LIMIT limitFrom , perPageNum
 LIMIT offset, size


MySQL :: MySQL 8.0 Reference Manual :: 13.2.10 SELECT Syntax https://dev.mysql.com/doc/refman/8.0/en/select.html

 　[LIMIT {[offset,] row_count | row_count OFFSET offset}]

 

 

offset从0开始计数 ：[0,totalRowsNum-1]

 

 

MySQL :: MySQL 8.0 Reference Manual :: 8.2.1.17 LIMIT Query Optimization https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html

 

 

posted @ 2018-10-17 11:56  papering  阅读(210)  评论(0)  编辑  收藏  举报