ROW_COUNT()

MySQL 8.4

ROW_COUNT() returns a value as follows:

Syntax

MYSQL

INSERT INTO t VALUES(1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           3 |
+-------------+
1 row in set (0.00 sec)

DELETE FROM t WHERE i IN(1,2);
Query OK, 2 rows affected (0.00 sec)

SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           2 |
+-------------+
1 row in set (0.00 sec)

Examples

Example

DDL statements: 0. This applies to statements such as CREATE TABLE or DROP TABLE.

MYSQL

INSERT INTO t VALUES(1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           3 |
+-------------+
1 row in set (0.00 sec)

DELETE FROM t WHERE i IN(1,2);
Query OK, 2 rows affected (0.00 sec)

SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           2 |
+-------------+
1 row in set (0.00 sec)