MySQL中实现分页查询的方法（mysql中分页查询）

Pagine query is a common operation in database systems, especially in Mysql databases. Today I will teach you how to implement pagine query in MySQL.

First of all,we must know the syntax of MySQL query. The following code is an example of a common query in MySQL:

`select * from table_name limit x, y`

This query statement means to query the data from the ‘table_name’ table and return the data with the offset x and the maximum number y. which means that it return the y number of data starting from the x-th data record.

For example, the query statement above, if x is 10 and y is 20, then it return the 20 records starting from the 10-th record.

The next step after knowing the base syntax of MySQL query is to understand how to use this function to implement the pagine query. In this process, we need a variable to store the page number. We need to do some calculations to translate the page number into the offset x and the maximum number y.

Let’s use a variable ‘page’ to store the page numebr.The first step is to calculate the value of x which used as the offset in the query:

`x = (page – 1) * 10;`

In the query statement， 10 can be replaced with any number depending on the number of records you want to query per page. After calculating the value of x, we can get the value of y by simply setting it to 10:

`y = 10;`

Now the variables x, y and page are ready, so we can make the query statement:

`select * from table_name limit x, y`;

By combining the page numbers and the offset limits, we can get the data we want to get per page.

To sum up, the realization of pagine query in MySQL requires the understanding of the query syntax and the use of the page numbers to get the offset and the maximum records per page. The query statement is as simple as described above. With the program of this statement, we can easily complete the pagine query task.