Copyright (C) 2000-2012 |
GNU Info (mysql.info)mysql_affected_rows`mysql_affected_rows()' ....................... `my_ulonglong mysql_affected_rows(MYSQL *mysql)' Description ........... Returns the number of rows changed by the last `UPDATE', deleted by the last `DELETE' or inserted by the last `INSERT' statement. May be called immediately after `mysql_query()' for `UPDATE', `DELETE', or `INSERT' statements. For `SELECT' statements, `mysql_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 where 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_affected_rows()' was called prior to calling `mysql_store_result()'. Errors ...... None. Example ....... mysql_query(&mysql,"UPDATE products SET cost=cost*1.25 WHERE group=10"); printf("%ld products updated",(long) mysql_affected_rows(&mysql)); If one specifies the flag `CLIENT_FOUND_ROWS' when connecting to `mysqld', `mysql_affected_rows()' will return the number of rows matched by the `WHERE' statement for `UPDATE' statements. Note that when one uses a `REPLACE' command, `mysql_affected_rows()' will return 2 if the new row replaced and old row. This is because in this case one row was inserted and then the duplicate was deleted. automatically generated by info2www version 1.2.2.9 |