Select Code to Download

ROW_COUNT() returns the number of rows changed, deleted, or inserted b
+y the last statement if it was an UPDATE, DELETE, or INSERT.

For UPDATE statements, the affected-rows value by default is the numbe
+r of rows actually changed. If you specify the CLIENT_FOUND_ROWS flag
+ to mysql_real_connect() when connecting to mysqld, the affected-rows
+ value is the number of rows “found”; that is, matched by the WHERE c
+lause.

Important
ROW_COUNT() is not replicated reliably.

my $rows = $dbh->selectrow_array( 'select row_count()' );