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, 207🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...