Shulou(Shulou.com)05/31 Report--

Mysql how to use paging limit statements, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Such a function has been provided for us.

SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offset

The LIMIT clause can be used to force the SELECT statement to return a specified number of records. LIMIT accepts one or two numeric parameters. Parameters must

Is an integer constant. If two parameters are given, the first parameter specifies the offset of the first returned record row, and the second parameter specifies that the return

The maximum number of rows recorded. The offset of the initial record row is 0 (not 1): MySQL also supports sentences for compatibility with PostgreSQL

Method: LIMIT # OFFSET #.

Mysql > SELECT * FROM table LIMIT 510; / / retrieve record lines 6-15

/ / to retrieve all record rows from a certain offset to the end of the recordset, you can specify the second parameter as-1:

Mysql > SELECT * FROM table LIMIT 95 96-last; / / search the record line.

/ / if only one parameter is given, it represents the maximum number of record rows returned:

Mysql > SELECT * FROM table LIMIT 5; / / retrieve the first five record rows

/ / in other words, LIMIT n is equivalent to LIMIT 0penny n.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.