ROW_COUNT() returns the number of rows updated, inserted, or deleted by the preceding statement. : ROW_COUNT « Information Functions « MySQL Tutorial






mysql>
mysql>
mysql> CREATE TABLE t (id INT NOT NULL);
Query OK, 0 rows affected (0.01 sec)

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

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

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

mysql>
mysql> SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
|           2 |
+-------------+
1 row in set (0.02 sec)

mysql>
mysql> drop table t;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>








20.11.ROW_COUNT
20.11.1.ROW_COUNT() returns the number of rows updated, inserted, or deleted by the preceding statement.