Description

The ROW_COUNT( ) function the number of rows changed by the previous SQL statement.

This function has the form:

SELECT ROW_COUNT()

Return Value

The number of rows updated, or -1 if no rows were changed.

Examples

The following example shows the basic use of this function:

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

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

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

mysql> SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           2 |
+-------------+