How to realize the pagination display of MySQL query results by using MySQL feature

This article will explain in detail how to use the MySQL feature to achieve the pagination display of MySQL query results. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The paging of query results can be easily realized by using a feature of select statement in mysql. Select

The grammar of a sentence:

SELECT [STRAIGHT_JOIN]

[SQL_SMALL_RESULT]

[SQL_BIG_RESULT]

[HIGH_PRIORITY]

[DISTINCT | DISTINCTROW | ALL]

Select_expression,...

[INTO OUTFILE 'file_name' export_options]

[FROM table_references

[WHERE where_definition]

[GROUP BY col_name,...]

[HAVING where_definition]

[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC],...]

[LIMIT [offset,] rows]

[PROCEDURE procedure_name]]

The LIMIT clause can be used to limit the amount of data returned by the SELECT statement, which has one or two parameters, such as

If two parameters are given, the first parameter specifies the position of the first row returned in all data, starting with 0 (note not 1)

The second parameter specifies the maximum number of rows returned. For example:

Select * from table LIMIT 5 10; # returns 6-15 rows of data

Select * from table LIMIT 5; # returns the first five lines

Select * from table LIMIT 0Pol 5; # return the first 5 lines

On "how to use MySQL features to achieve paging display of MySQL query results" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.