Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
FOUND_ ROWS
On this page
Returns the number of rows when using commands that return a resultset, such as SELECT
, DESC
, and SHOW
.
Syntax
FOUND_ROWS()
Arguments
-
None
Return Type
int
Examples
SHOW TABLES;
+--------------+
| Tables_in_db |
+--------------+
| testdata |
+--------------+
SELECT FOUND_ROWS();
+--------------+
| FOUND_ROWS() |
+--------------+
| 1 |
+--------------+
SELECT ID FROM neighborhoods LIMIT 2;
+------+
| id |
+------+
| 1 |
| 3 |
+------+
SELECT FOUND_ROWS();
+--------------+
| FOUND_ROWS() |
+--------------+
| 2 |
+--------------+
SELECT * FROM testdata;
+----------+
| Results |
+----------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+----------+
SELECT FOUND_ROWS;
+--------------+
| FOUND_ROWS() |
+--------------+
| 5 |
+--------------+
DESC testdata;
+-------+---------+------+------+---------+-----------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+------+---------+-------+
| id | int(10) | NO | | NULL | |
+--------+------------+------+------+---------+-------+
| name | varchar(64)| NO | | NULL | |
+--------+------------+------+------+---------+-------+
| amount | int(10) | NO | | NULL | |
+-------+---------+------+------+---------+-----------+
SELECT FOUND_ROWS;
+--------------+
| FOUND_ROWS() |
+--------------+
| 1 |
+--------------+
Note
Please note, there can be an incorrect result given when running a query using LIMIT
with an offset.
CREATE TABLE t1(a BIGINT PRIMARY KEY AUTO_INCREMENT, b INT);INSERT random integers into t1 so total row count is greater than LIMIT argument.SELECT COUNT(*) FROM t1 GROUP BY a ORDER BY a LIMIT 5,10;+----------+| COUNT(*) |+----------+| 1 || 1 || 1 || 1 || 1 || 1 || 1 || 1 || 1 || 1 |+----------+10 rows in set (0.03 sec)SELECT FOUND_ROWS(); -- the result should be 10+--------------+| FOUND_ROWS() |+--------------+| 15 |+--------------+1 row in set (0.00 sec)
Last modified: April 4, 2023