Forum und email
MySQL
PHP Manual

mysql_info

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

mysql_info — Get information about the most recent query

說明

string mysql_info ([ resource $link_identifier ] )

Returns detailed information about the last query.

參數

link_identifier

MySQL 的連接識別符。如果沒有指定，預設使用最後被 mysql_connect() 打開的連接。如果沒有找到該連接，函式會嘗試呼叫 mysql_connect() 建立連接並使用它。如果發生意外，沒有找到連接或無法建立連接，系統發出 E_WARNING 級別的警告信息。

Return值

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.

範例

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

註釋

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

參見

MySQL
PHP Manual