Name
Mysql::Statement::info
Synopsis
$info = $sth->info;
Mysql::Statement::info
returns extra results from
certain queries that do not have specialized functions in
Mysql.pm
, such as ALTER TABLE
and LOAD DATA INFILE
. For example, when using
LOAD DATA INFILE
,
Mysql::Statement::info
returns the number of
records inserted, the number deleted, the number skipped and the
number of unparsable entries.
Example
use Mysql; $db = Mysql->connect(undef,'mydata'); my $output = $db->query("LOAD DATA INFILE 'mydata.dat' INTO TABLE mytable"); my $info = $output->info($output); print "LOAD DATA result: $info\n";
Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.