【MySQL】UPDATE・DELETE・INSERT実行後に処理件数を取得する方法 - Qiita

-- UPDATE mysql> UPDATE animals SET name = 'dog' WHERE name = 'wolf'; Query OK, 7 rows affected (0.00 sec) Rows matched: 7 Changed: 7 Warnings: 0 mysql> SELECT ROW_COUNT(); +-------------+ | ROW_COUNT() | +-------------+ | 7 | +-------------+ 1 row in set (0.00 sec) -- DELETE mysql> DELETE FROM animals WHERE id = 3; Query OK, 1 row affected (0.00 sec) mysql> SELECT ROW_COUNT(); +-------------+ | R