Detailed analysis of MySQL limit usage

Detailed analysis of MySQL limit usage when we use related query statements, we generally need to return the first few or a few rows of data in the middle. What should you do? Don't worry, MySQL database already provides us with such a function. The SELECT * FROM table LIMIT [offset,] rows | rows offset limit clause can be used to force the SELECT statement to return the specified number of records. MySQL LIMIT accepts one or two numeric parameters. The parameter must be 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 the maximum number of returned record rows. the offset of the initial record row is 0 rather than 1 ). To be compatible with PostgreSQL, MySQL also supports Syntax: LIMIT # OFFSET #. Www.2cto.com 1 MySQL> SELECT * FROM table LIMIT 5, 10; Retrieve record Row 6-15 in order to retrieve all record rows FROM an offset to the end of the record set, you can specify the second parameter-1: 1 MySQL> SELECT * FROM table LIMIT 95,-1; to retrieve the record row 96-last. if only one parameter is specified, it indicates that the maximum number of record rows is returned: 1 MySQL> SELECT * FROM table LIMIT 5; the first five record rows are retrieved. In other words, LIMIT n is equivalent to MySQL LIMIT 0, n.