Msql 1.2219

Msql is a Perl interface to the mSQL and mysql databases.

SYNOPSIS

use Msql;

$dbh = Msql->connect($host);
$dbh = Msql->connect($host, $database);

or

use Mysql;

$dbh = Mysql->connect(undef, $database, $user, $password);
$dbh = Mysql->connect($host, $database, $user, $password);

or

$dbh = Msql1->connect($host);
$dbh = Msql1->connect($host, $database);


$dbh->selectdb($database);

@arr = $dbh->listdbs;
@arr = $dbh->listtables;

$quoted_string = $dbh->quote($unquoted_string);
$error_message = $dbh->errmsg;
$error_number = $dbh->errno; # MySQL only

$sth = $dbh->listfields($table);
$sth = $dbh->query($sql_statement);

@arr = $sth->fetchrow; # Array context
$firstcol = $sth->fetchrow; # Scalar context
@arr = $sth->fetchcol($col_number);
%hash = $sth->fetchhash;

$sth->dataseek($row_number);

$sth->as_string;

@indices = $sth->listindices # only in mSQL 2.0
@arr = $dbh->listindex($table,$index) # only in mSQL 2.0
($step,$value) = $dbh->getsequenceinfo($table) # only in mSQL 2.0

$rc = $dbh->shutdown();
$rc = $dbh->createdb($database);
$rc = $dbh->dropdb($database);