DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) mysql_affected_rows

Info Catalog (mysql.info.gz) C API functions (mysql.info.gz) C API functions (mysql.info.gz) mysql_change_user
 
 22.2.3.1 `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 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_affected_rows()' was called
 prior to calling `mysql_store_result()'. Because `mysql_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).
 
 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 you specify 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 you use a `REPLACE' command, `mysql_affected_rows()'
 returns 2 if the new row replaced an old row.  This is because in this
 case one row was inserted after the duplicate was deleted.
 
 If you use `INSERT ... ON DUPLICATE KEY UPDATE' to insert a row,
 `mysql_affected_rows()' returns 1 if the row is inserted as a new row
 and 2 if an existing row is updated.
 
Info Catalog (mysql.info.gz) C API functions (mysql.info.gz) C API functions (mysql.info.gz) mysql_change_user
automatically generated byinfo2html