(mysql.info) mysql-stmt-affected-rows
Info Catalog
(mysql.info) c-api-prepared-statement-functions
(mysql.info) c-api-prepared-statement-functions
(mysql.info) mysql-stmt-attr-get
22.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 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 mysql-stmt-execute.
Info Catalog
(mysql.info) c-api-prepared-statement-functions
(mysql.info) c-api-prepared-statement-functions
(mysql.info) mysql-stmt-attr-get
automatically generated byinfo2html