mysql_info

mysql_info

Get information about the most recent query

Waarschuwing: > mysqli_info

string **mysql_info** resource $link_identifier

Returns detailed information about the last query.

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.

Voorbeeld: Relevant MySQL Statements

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

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

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

mysql_affected_rows``mysql_insert_id``mysql_stat