Collections:
Returning the Second 5 Rows in MySQL
How To Return the Second 5 Rows in MySQL?
✍: FYIcenter.com
If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. You can use the "LIMIT startRow maxRows" clause to return only rows starting from "startRow" to "startRow+maxRows-1". Note that MySQL counts output rows starting with 0.
The following statement returns the second 5 rows first from the fyi_links table:
mysql> SELECT id, url, counts, tag FROM fyi_links ORDER BY counts DESC LIMIT 5, 5; -- the first "5" means starting with row #6. +-----+-------------------+--------+------+ | id | url | counts | tag | +-----+-------------------+--------+------+ | 102 | dba.fyicenter.com | 3 | DBA | | 104 | www.mysql.com | 1 | DBA | +-----+-------------------+--------+------+ 2 rows in set (0.00 sec)
⇒ Merge Outputs from Two Queries in MySQL
⇐ Returning Top 5 Rows in MySQL
2017-12-21, 1383🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...