FreeBSD Manual Pages
mysql_affected_rows(3) MariaDB Connector/C mysql_affected_rows(3) Name mysql_affected_rows - returns the number of rows affected by the last operation Synopsis #include <mysql.h> my_ulonglong mysql_affected_rows(MYSQL * mysql); Description Returns the number of affected rows by the last operation associated with mysql, if the operation was an "upsert" (INSERT, UPDATE, DELETE or REPLACE) statement, or -1 if the last operation failed. Parameters: mysql is a connection identifier, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). Notes: • When using UPDATE, MariaDB will not update columns where the new value is the same as the old value. This creates the possibility that mysql_affected_rows may not actually equal the number of rows matched, only the number of rows that were literally affected by the query. • The REPLACE statement first deletes the record with the same primary key and then inserts the new record. This function returns the num- ber of deleted records in addition to the number of inserted records. Return value Returns the number of affected rows or -1 on error. See also • mysql_num_rows(3) Version 3.4 mysql_affected_rows(3)
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mysql_affected_rows&sektion=3&manpath=FreeBSD+Ports+14.3.quarterly>