20.4.27 mysql_info()

char *mysql_info(MYSQL *mysql)

20.4.27.1 Description

Retrieves a string providing information about the most recently executed query, but only for the statements listed below. For other statements, mysql_info() returns NULL. The format of the string varies depending on the type of query, as described below. The numbers are illustrative only; the string will contain values appropriate for the query.

INSERT INTO ... SELECT ...
String format: Records: 100 Duplicates: 0 Warnings: 0
INSERT INTO ... VALUES (...),(...),(...)...
String format: Records: 3 Duplicates: 0 Warnings: 0
LOAD DATA INFILE ...
String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
ALTER TABLE
String format: Records: 3 Duplicates: 0 Warnings: 0

Note that mysql_info() returns a non-NULL value for the INSERT ... VALUES statement only if multiple value lists are specified in the statement.

20.4.27.2 Return values

A character string representing additional information about the most recently executed query. NULL if no information is available for the query.

20.4.27.3 Errors

None.