DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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