Name
mysql_affected_rows
Synopsis
my_ulonglong mysql_affected_rows(MYSQL *mysql)
Returns the number of rows affected by the most recent query. When
used with a non-SELECT query, it can be used after
the mysql_query call that sent the query. With
SELECT, this function is identical to
mysql_num_rows.
Example
/* Insert a row into the people table */
mysql_query(&mysql, "INSERT INTO people VALUES ('', 'Illyana Rasputin', 16)";
num = mysql_affected_rows(&mysql);
/* num should be 1 if the INSERT (of a single row) was successful, and -1 if
there was an error */Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
