mysql_info()

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: 0

• INSERT INTO ... VALUES (...),(...),(...)...

  String format: Records: 3 Duplicates: 0 Warnings: 0

• LOAD DATA

  String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0

• ALTER TABLE

  String format: Records: 3 Duplicates: 0 Warnings: 0

• UPDATE

  String 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).