mysql_info() - mysql/mysql.h
Retrieves a string providing information about the most recently
executed statement, but only for the statements listed here. For
other statements, mysql_info()
returns NULL. The format of the string varies
depending on the type of statement, as described here. The
numbers are illustrative only; the string contains values
appropriate for the statement.mysql_info()mysql_info()NULLINSERT 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
UPDATE
String format: Rows matched: 40 Changed: 40
Warnings: 0INSERT 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
UPDATE
String format: Rows matched: 40 Changed: 40
Warnings: 0INSERT INTO
... SELECT ...
String format: Records: 100 Duplicates: 0 Warnings:
0INSERT INTO
... SELECT ...INSERT INTO
... SELECT ...INSERT INTO
... SELECT ...String format: Records: 100 Duplicates: 0 Warnings:
0Records: 100 Duplicates: 0 Warnings:
0INSERT INTO ... VALUES
(...),(...),(...)...
String format: Records: 3 Duplicates: 0 Warnings:
0INSERT INTO ... VALUES
(...),(...),(...)...INSERT INTO ... VALUES
(...),(...),(...)...String format: Records: 3 Duplicates: 0 Warnings:
0Records: 3 Duplicates: 0 Warnings:
0LOAD DATA INFILE
...
String format: Records: 1 Deleted: 0 Skipped: 0
Warnings: 0LOAD DATA INFILE
...LOAD DATA INFILE
...LOAD DATA INFILE
...String format: Records: 1 Deleted: 0 Skipped: 0
Warnings: 0Records: 1 Deleted: 0 Skipped: 0
Warnings: 0ALTER TABLE
String format: Records: 3 Duplicates: 0 Warnings:
0ALTER TABLEALTER TABLEALTER TABLEString format: Records: 3 Duplicates: 0 Warnings:
0Records: 3 Duplicates: 0 Warnings:
0UPDATE
String format: Rows matched: 40 Changed: 40
Warnings: 0UPDATEUPDATEUPDATEString format: Rows matched: 40 Changed: 40
Warnings: 0Rows matched: 40 Changed: 40
Warnings: 0mysql_info() returns a
non-NULL value for
INSERT ...
VALUES only for the multiple-row form of the statement
(that is, only if multiple value lists are specified).mysql_info()mysql_info()NULLINSERT ...
VALUESINSERT ...
VALUES
Syntax
const char *mysql_info(MYSQL *mysql)
Example
Output / Return Value
A character string representing additional information about the
most recently executed statement. NULL if no
information is available for the statement.NULL
Limitations
Alternatives / See Also
Reference