25.2.7.1. mysql_stmt_affected_rows()
my_ulonglong mysql_stmt_affected_rows(MYSQL_STMT
*stmt)
Description
Returns the total number of rows changed, deleted, or inserted
by the last executed statement. May be called immediately
after mysql_stmt_execute() for
UPDATE, DELETE, or
INSERT statements. For
SELECT statements,
mysql_stmt_affected_rows() works like
mysql_num_rows().
Return Values
An integer greater than zero indicates the number of rows
affected or retrieved. Zero indicates that no records were
updated for an UPDATE statement, no rows
matched the WHERE clause in the query, or
that no query has yet been executed. -1 indicates that the
query returned an error or that, for a
SELECT query,
mysql_stmt_affected_rows() was called prior
to calling mysql_stmt_store_result().
Because mysql_stmt_affected_rows() returns
an unsigned value, you can check for -1 by comparing the
return value to (my_ulonglong)-1 (or to
(my_ulonglong)~0, which is equivalent).
See Section 25.2.3.1, “mysql_affected_rows()”, for additional
information on the return value.
Errors
None.
Example
For the usage of
mysql_stmt_affected_rows(), refer to the
Example from Section 25.2.7.10, “mysql_stmt_execute()”.
