mysql_info
(PHP 4 >= 4.3.0, PHP 5)
mysql_info --
Get information about the most recent query
Description
string
mysql_info ( [resource link_identifier])
mysql_info() returns detailed information about
the last query using the given link_identifier.
If link_identifier isn't specified, the last
opened link is assumed.
mysql_info() returns a string for all statements
listed below. For everything else, it returns FALSE. The string
format depends on the given statement.
Example 1. Relevant MySQL Statements 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 |
|
The numbers are only for illustrating purpose; their values will
correspond to the query.
Note:
mysql_info() returns a non-FALSE value for the
INSERT ... VALUES statement only if multiple value lists are
specified in the statement.
See also
mysql_affected_rows(),
mysql_insert_id(), and
mysql_stat().