MySQL paging implementation

MySQL paging implementation

Mysql> select pname from product; + -------- + | pname | + -------- + | product 1 | product 2 | product 3 | + -------- + 3 rows in set (0.00 sec)

In this case, all pnames are selected from the product. There are three records in total. Paging in MySQL is very simple. We can use limit for example:

Mysql> select pname from product limit 0.00; + ------- + | pname | + ------- + | product 1 | product 2 | + ------- + 2 rows in set (sec)

Limit is used as follows: the first parameter refers to the start point, and the second parameter refers to the number of data entries displayed on each page. Note: The first page is represented by 0. Mysql paging: select * from tableName where condition limit current page number * Page capacity-1 page capacity