Collections:
FOUND_ROWS() - Row Count from Last SELECT Statement
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?
✍: FYIcenter.com
FOUND_ROWS() is a MySQL built-in function that returns the number of rows found by the last SELECT statement. For example:
SELECT help_topic_id, name FROM mysql.help_topic; -- +---------------+------------------------------------+ -- | help_topic_id | name | -- +---------------+------------------------------------+ -- | 65 | ! | -- | 47 | != | -- | 140 | % | -- | 238 | & | -- | 137 | * | -- ... -- +---------------+------------------------------------+ 682 rows in set (0.01 sec) SELECT FOUND_ROWS(); -- +--------------+ -- | FOUND_ROWS() | -- +--------------+ -- | 682 | -- +--------------+
If the LIMIT clause is used in the SELECT statement, you need to use the "SELECT SQL_CALC_FOUND_ROWS" statement to give you the correct total rows found value. For example:
SELECT help_topic_id, name FROM mysql.help_topic LIMIT 3; -- +---------------+------+ -- | help_topic_id | name | -- +---------------+------+ -- | 65 | ! | -- | 47 | != | -- | 140 | % | -- +---------------+------+ SELECT FOUND_ROWS(); -- +--------------+ -- | FOUND_ROWS() | -- +--------------+ -- | 3 | -- +--------------+ SELECT SQL_CALC_FOUND_ROWS help_topic_id, name FROM mysql.help_topic LIMIT 3; -- +---------------+------+ -- | help_topic_id | name | -- +---------------+------+ -- | 65 | ! | -- | 47 | != | -- | 140 | % | -- +---------------+------+ SELECT FOUND_ROWS(); -- +--------------+ -- | FOUND_ROWS() | -- +--------------+ -- | 682 | -- +--------------+
Reference information of the FOUND_ROWS() function:
FOUND_ROWS(): count Returns the number of rows found by the last SELECT statement. Arguments, return value and availability: count: Return value. The number of rows found by the last SELECT statement. Available since MySQL 4.0.
⇒ ICU_VERSION() - ICU (International Components for Unicode) Version
⇐ DATABASE() - Name of Current Database
2023-12-19, 199🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...