mysql_stmt_affected_rows - Online Linux Manual PageSection : 3
Updated :
Source : Version 3.2.2
Note : MariaDB Connector/C

---

Namemysql_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);

---

DescriptionReturns the number of affected rows by the last prepared statement associated 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 number of deleted records in addition to the number of inserted records.

---

See Also• mysql_stmt_insert_id(3) 0

---

Johanes Gumabo

---

Data Size   :   5,072 byte
man-mysql_stmt_affected_rows.3Build   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   2 / 189,183
Visitor ID   :     :  
Visitor IP   :   18.118.164.100   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36

---

Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .

---

If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.

---