DBD::mSQL 1.2219

DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI). SYNOPSIS use DB

Developer:   Jochen Wiedmann       more software by author → Price:  0.00 License:   Perl Artistic License File size:   191K Language:    OS:    Rating:   0 /5 (0 votes) Your vote:   enlarge screenshot

DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI).

SYNOPSIS

use DBI;

$driver = "mSQL"; # or "mSQL1";
$dsn = "DBI:$driver:database=$database;host=$hostname";

$dbh = DBI->connect($dsn, undef, undef);

or

$driver = "mysql";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";

$dbh = DBI->connect($dsn, $user, $password);


$drh = DBI->install_driver("mysql");
@databases = $drh->func($host, $port, '_ListDBs');
@tables = $dbh->func( '_ListTables' );

$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{'NUM_OF_FIELDS'};
$sth->finish;

$rc = $drh->func('createdb', $database, $host, $user, $password, 'admin');
$rc = $drh->func('dropdb', $database, $host, $user, $password, 'admin');
$rc = $drh->func('shutdown', $host, $user, $password, 'admin');
$rc = $drh->func('reload', $host, $user, $password, 'admin');

$rc = $dbh->func('createdb', $database, 'admin');
$rc = $dbh->func('dropdb', $database, 'admin');
$rc = $dbh->func('shutdown', 'admin');
$rc = $dbh->func('reload', 'admin');

EXAMPLE

#!/usr/bin/perl

use strict;
use DBI();

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joe's password",
{'RaiseError' => 1});

# Drop table 'foo'. This may fail, if 'foo' doesn't exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;

# Create a new table 'foo'. This must not fail, thus we don't
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");

# INSERT some data into 'foo'. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");

# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");

# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{'id'}, name = $ref->{'name'}n";
}
$sth->finish();

# Disconnect from the database.
$dbh->disconnect();

DBD::mysql and DBD::mSQL are the Perl5 Database Interface drivers for the mysql, mSQL 1.x and mSQL 2.x databases. The drivers are part of the Msql-Mysql-modules package.
In other words: DBD::mSQL and DBD::mysql are an interface between the Perl programming language and the mSQL or mysql programming API that come with the mSQL any mysql relational database management systems. Most functions provided by the respective programming API's are supported. Some rarely used functions are missing, mainly because noone ever requested them.

Requirements:

Perl
tags dbh func  user password  drh func  database host  table foo  host user  dbi connect  password admin  sth dbh  dbh prepare  dbh dbi  dbi driver  the msql  

Download DBD::mSQL 1.2219

 http://mirrors.evolva.ro/CPAN/authors/id/J/JW/JWIED/Msql-Mysql-modules-1.2219.tar.gz

Authors software

JaxMe 0.5.2 (by Jochen Wiedmann) JaxMe project is an open source implementation of JAXB, the specification for Java/XML binding. A Java/XML binding compiler takes

DBD::mysql 3.0007 (by Jochen Wiedmann) DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI). SYNOPSIS use DBI; $dsn = "DBI:

DBD::mSQL 1.2219 (by Jochen Wiedmann) DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI). SYNOPSIS use DB

Similar software

DBD::mSQL 1.2219 (by Jochen Wiedmann) DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI). SYNOPSIS use DB

DBD::mysql 3.0007 (by Jochen Wiedmann) DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI). SYNOPSIS use DBI; $dsn = "DBI:

Template::Tutorial 2.15 (by Andy Wardley) Template::Tutorial are template toolkit tutorials. This section includes tutorials on using the Template Toolkit

MathML::Entities 0.13 (by Jacques Distler) MathML::Entities is a Perl module that can convert XHTML+MathML Named Entities to Numeric Character References. SYNOPSIS use M

DBI::FAQ 1.52 (by Alligator Descartes) DBI::FAQ is a Perl module for the Frequently Asked Questions of the Perl5 Database Interface. What is DBI, DBperl, Oraperl and *pe

DocServ 1.0 (by Antoine Duval) DocServ is a small tool for indexing documents in a database. It is easy to use, and can be installed in less than 5 minutes. R

DBIx::SQL::Abstract 0.07 (by Alejandro Juarez)

Media Database 0.1 (by Andre Pedersen) Media Database is a media database that uses PHP for the GUI and MySQL for data storage. It has movie, series, and anime listings

Dispatch Software 1.12b (by Dispatch Software Team) Dispatch Software is a software that saves time, money and increase your customer satisfaction

PAM ListMySQL Module 0.1.3 (by Rodrigo S Wanderley) PAM ListMySQL Module joins the functionality of both pam_mysql and pam_listfile

Other software in this category

zlib 1.2.3 (by Jean-loup Gailly) zlib is designed to be a free, general-purpose, legally unencumbered, lossless data-compression library for use on virtually any comp

libjpeg v6b (by Independent JPEG Group) libjpeg is a library for handling the JPEG (JFIF) image format

OpenSSL 0.9.7c (by The OpenSSL Project Team) The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implement

libxml2 2.6.27 (by DV) Libxml2 is the XML C parser and toolkit developed for the Gnome project (but usable outside of the Gnome platform), libxml2 library i

GNU C library 2.4 (by Andreas Jaeger) GNU C library (glibc) is one of the most important components of GNU Hurd and most modern Linux distributions. GNU C library is us