diff options
Diffstat (limited to 'libmariadb/man/mysql_stmt_affected_rows.3')
| -rw-r--r-- | libmariadb/man/mysql_stmt_affected_rows.3 | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/libmariadb/man/mysql_stmt_affected_rows.3 b/libmariadb/man/mysql_stmt_affected_rows.3 new file mode 100644 index 00000000..d7b2f1de --- /dev/null +++ b/libmariadb/man/mysql_stmt_affected_rows.3 @@ -0,0 +1,42 @@ +.\" Automatically generated by Pandoc 2.5 +.\" +.TH "mysql_stmt_affected_rows" "3" "" "Version 3.3.1" "MariaDB Connector/C" +.hy +.SS Name +.PP +mysql_stmt_affected_rows \- Returns the number of affected rows from +previous executed prepared statement +.SS Synopsis +.IP +.nf +\f[C] +#include <mysql.h> + +my_ulonglong mysql_stmt_affected_rows(MYSQL_STMT * stmt); +\f[R] +.fi +.SS Description +.PP +Returns the number of affected rows by the last prepared statement +associated with mysql, if the operation was an \[lq]upsert\[rq] (INSERT, +UPDATE, DELETE or REPLACE) statement, or \-1 if the last prepared +statement failed. +.SS Parameter +.IP \[bu] 2 +\f[C]stmt\f[R] \- a statement handle, which was previously allocated by +[mysql_stmt_init()](mysql_stmt_init().]] +.SS Notes +.IP \[bu] 2 +When using \f[C]UPDATE\f[R], MariaDB will not update columns where the +new value is the same as the old value. +This creates the possibility that \f[C]mysql_stmt_affected_rows()\f[R] +may not actually equal the number of rows matched, only the number of +rows that were literally affected by the query. +.IP \[bu] 2 +The \f[C]REPLACE\f[R] statement first deletes the record with the same +primary key and then inserts the new record. +This function returns the number of deleted records in addition to the +number of inserted records. +.SS See Also +.IP \[bu] 2 +\f[B]mysql_stmt_insert_id(3)\f[R] |