Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

FOUND_ROWS

Syntax

SQL

FOUND_ROWS()

Arguments

None

Return Type

int

Examples

SQL

SHOW TABLES;

+--------------+
| Tables_in_db |
+--------------+
| testdata     |
+--------------+

SQL

SELECT FOUND_ROWS();

+--------------+
| FOUND_ROWS() |
+--------------+
|            1 |
+--------------+

SQL

SELECT ID FROM neighborhoods LIMIT 2;

+------+
| id   |
+------+
|    1 |
|    3 |
+------+

SQL

SELECT FOUND_ROWS();

+--------------+
| FOUND_ROWS() |
+--------------+
|            2 |
+--------------+

SQL

SELECT * FROM testdata;

+----------+
| Results  |
+----------+
|        1 |
|        2 |
|        3 |
|        4 |
|        5 |
+----------+

SQL

SELECT FOUND_ROWS;

+--------------+
| FOUND_ROWS() |
+--------------+
|            5 |
+--------------+

SQL

DESC testdata;

+-------+---------+------+------+---------+-----------+
| Field  | Type       | Null | Key  | Default | Extra |
+-------+-------------+------+------+---------+-------+
| id     | int(10)    | NO   |      | NULL    |       |
+--------+------------+------+------+---------+-------+
| name   | varchar(64)| NO   |      | NULL    |       |
+--------+------------+------+------+---------+-------+
| amount | int(10)    | NO   |      | NULL    |       |
+-------+---------+------+------+---------+-----------+

SQL

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. See the following example:

SQL

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)

FOUND_ROWS

On this page

Syntax

Arguments

Return Type

Examples

Was this article helpful?

On this page

Was this article helpful?