MySQL _ data paging query (limit usage) _ MySQL

MySQL _ data paging query (limit usage) bitsCN.com

MySQL _ data paging query (limit usage)

Take the first five data records [SQL] select * from table_name limit 11th, or [SQL] select * from table_name limit 5, and obtain 15th to data records, five [SQL] select * from table_name limit 10, 5 use of the limit keyword: LIMIT [offset,] rows

Offset specifies the offset of the first row to be returned, and rows specifies the maximum number of returned rows.

The offset of the initial row is 0 (not 1 ).

BitsCN.com