Forum und email

mysql_info

(PHP 4 >= 4.3.0, PHP 5, PECL mysql:1.0)

mysql_info — Get information about the most recent query

Popis

string mysql_info ([ resource $link_identifier ] )

Returns detailed information about the last query.

Parametre

link_identifier

Pripojenie k MySQL. Ak link identifier nie je zadaný, predpokladá sa posledné spojenie otvorené s mysql_connect(). Ak také spojenie nie je nájdené, pokúsi sa jedno vytvoriť ako keby bolo volané mysql_connect() bez argumentov. Ak sa náhodou nájde pripojenie, alebo je vytvorené, je vygenerované varovanie úrovne E_WARNING.

Vrátené hodnoty

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.

Príklady

Example#1 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

Poznámky

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