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; + ------- + | pname | + ------- + | product 1 | product 2 | + ------- + 2 rows in set (0.00 sec) Limit usage: the first parameter indicates the start point, and the second parameter indicates the number of data entries displayed on each page. Note: 0 indicates the first page.

Mysql page:

Select * from tableName where Condition LimitCurrent page number * Page capacity-1, page capacity