DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) mysql_stmt_affected_rows

Info Catalog (mysql.info.gz) C API Prepared statement functions (mysql.info.gz) C API Prepared statement functions (mysql.info.gz) 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()'.
 
 This function was added in MySQL 4.1.0.
 
 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()' 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()' mysql_stmt_execute.
 
Info Catalog (mysql.info.gz) C API Prepared statement functions (mysql.info.gz) C API Prepared statement functions (mysql.info.gz) mysql_stmt_attr_get
automatically generated byinfo2html