MySQL and mSQL

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";