Mysql Paging Query

Straight to the subject

One, SQL statement: SELECT * FROM table limit Startpagenum,everypagenum

1) Statement parsing:

Table: The tables you want to query

Startpagenum: Starting from how many bars

Everypagenum: Number of pages per page

More than two, the SQL statement can be written as follows:

SELECT * FROM table limit (page*everypagenum), Everypagenum

2) Statement parsing:

Table: The tables you want to query

Page: page

Everypagenum: Number of pages per page

(Page*everypagenum) =startpagenum

Third, Focus: keyword limit

Summary: The above two statements can be distinguished is one is in the program to calculate the starting bar number, the other is in the SQL statement to work out the number of bars, personal advice or in the program is counted well and then brought into the database query.

====== wish you a happy life ======

Mysql Paging Query