Home/ Manual/ mysql / functions/ mysql_info

mysql_info

PHP function Edit on GitHub ✎

(PHP 4 >= 4.3.0, PHP 5)

Get information about the most recent query

Note mysqli_info

Description

mysql_info(resource $link_identifier = NULL): string

Returns detailed information about the last query.

Parameters

Return Values

Returns information about the statement on success, or false on failure. See the example below for which statements provide information, and what the returned value may look like. Statements that are not listed will return false.

Examples

Relevant MySQL Statements

Statements that return string values. The numbers are only for illustrating purpose; their values will correspond to the query.

mysql

INSERT INTO ... SELECT ...
String format: Records: 23 Duplicates: 0 Warnings: 0
INSERT INTO ... VALUES (...),(...),(...)...
String format: Records: 37 Duplicates: 0 Warnings: 0
LOAD DATA INFILE ...
String format: Records: 42 Deleted: 0 Skipped: 0 Warnings: 0
ALTER TABLE
String format: Records: 60 Duplicates: 0 Warnings: 0
UPDATE
String format: Rows matched: 65 Changed: 65 Warnings: 0

Notes

Note

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