Shulou(Shulou.com)06/01 Report--

This article is mainly about the use of Select Limit in MySQL, if you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading the usage of Select Limit in MySQL.

The LIMIT clause can be used to constrain the number of rowsreturned by the SELECT statement.

LIMIT takes one or two numeric arguments,which must both be nonnegative integer constants, with these exceptions:

Limit can be followed by 1 or 2 × × parameters, which must be non-negative integer constants.

Within prepared statements, LIMIT parameters can be specified using? Placeholder markers.

The limit parameter can be used in precompiled sentences. Placeholder.

Within stored programs, LIMIT parameters can be specified usinginteger-valued routine

Parameters or local variables.

With two arguments, the first argumentspecifies the offset of the first row to return, and the second specifies themaximum number of rows to return. The offset of theinitial row is 0 (not 1):

SELECT * FROM tbl LIMIT5,10; # Retrieve rows 6-15

To retrieve all rows from a certain offsetup to the end of the result set, you can use some large

Number for the second parameter. This statement retrieves all rows from the 96th row to thelast:

SELECT * FROM tbl LIMIT95,18446744073709551615

With one argument, the value specifies thenumber of rows to return from the beginning of the result set:

SELECT * FROM tbl LIMIT5; # Retrieve first 5 rows, return the first 5 lines

In other words, LIMIT row_count isequivalent to LIMIT 0, row_count.

For prepared statements, you can useplaceholders. The following statements will return one row

From the tbl table:

SET @ axi1

PREPARE STMT FROM 'SELECT* FROM tbl LIMIT?'

EXECUTE STMT USING @ a

The following statements will return thesecond to sixth row from the tbl table:

SET@ skip=1; SET@numrows=5

PREPARE STMT FROM 'SELECT* FROM tbl LIMIT?'

EXECUTE STMT USING @ skip,@numrows

For compatibility with PostgreSQL, MySQLalso supports the LIMIT row_count OFFSET offset

Syntax.

If LIMIT occurs within a subquery and alsois applied in the outer query, the outermost LIMIT takes

Precedence. For example, the followingstatement produces two rows, not one:

(SELECT... LIMIT 1) LIMIT 2

The above details about the use of Select Limit in MySQL are helpful to all of you. If you want to know more about it, you can continue to follow our industry information section.

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.