You can call the mysql_info() function to return a string of information about the most recently executed statement.
Syntax
const char *
mysql_info(MYSQL *mysql)
Return values
A string representing additional information about the most recently executed statement is returned. NULL is returned if no information is available for the statement.
Errors
None.
Notes
The format of the string varies with the type of statements. Sample statement:
INSERT INTO ... SELECT ...String format:
Records: 100 Duplicates: 0 Warnings: 0INSERT INTO ... VALUES (...),(...),(...)...String format:
Records: 3 Duplicates: 0 Warnings: 0LOAD DATAString format:
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0ALTER TABLEString format:
Records: 3 Duplicates: 0 Warnings: 0UPDATEString format:
Rows matched: 40 Changed: 40 Warnings: 0
mysql_info() returns a non-NULL value for INSERT ... VALUES only for multi-row statements (only if multiple value lists are specified).