FreeBSD Manual Pages
mysql_stmt_affected_rows(3) MariaDB Connector/C mysql_stmt_affected_rows(3)
Name
mysql_stmt_affected_rows - Returns the number of affected rows from
previous executed prepared statement
Synopsis
#include <mysql.h>
my_ulonglong mysql_stmt_affected_rows(MYSQL_STMT * stmt);
Description
Returns the number of affected rows by the last prepared statement as-
sociated with mysql, if the operation was an "upsert" (INSERT, UPDATE,
DELETE or REPLACE) statement, or -1 if the last prepared statement
failed.
Parameter
• stmt - a statement handle, which was previously allocated by
[mysql_stmt_init()](mysql_stmt_init().]]
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_stmt_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.
See Also
• mysql_stmt_insert_id(3)
Version 3.4 mysql_stmt_affected_rows(3)
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mysql_stmt_affected_rows&sektion=3&manpath=FreeBSD+Ports+14.3.quarterly>