4.16. Info

[<<<] [>>>]

A$ = mysql::Info(dbh)

This function retrieves a string providing information about the most recently executed query, but only for the statements listed below. For other statements, mysql::Info() returns undef. The format of the string varies depending on the type of query, as described below. The numbers are illustrative only; the string will contain values appropriate for the query.

INSERT INTO ... SELECT ... 
String format: Records: 100 Duplicates: 0 Warnings: 0 
INSERT INTO ... VALUES (...),(...),(...)... 
String format: Records: 3 Duplicates: 0 Warnings: 0 
LOAD DATA INFILE ... 
String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 
ALTER TABLE 
String format: Records: 3 Duplicates: 0 Warnings: 0 
UPDATE 
String format: Rows matched: 40 Changed: 40 Warnings: 0 

Note that mysql::Info() returns a string value for the INSERT ... VALUES statement only if multiple value lists are specified in the statement. Otherwise it returns undef.


[<<<] [>>>]