You are here : Cmysql/mysql.hmysql_info

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