Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 32.284.176 Times

DBD::mysql 4.004

  Date Added: February 01, 2010  |  Visits: 705

DBD::mysql

Report Broken Link
Printer Friendly Version


Product Homepage
Download (77 downloads)

DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI). SYNOPSIS use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port"; $dbh = DBI->connect($dsn, $user, $password); $drh = DBI->install_driver("mysql"); @databases = DBI->data_sources("mysql"); or @databases = DBI->data_sources("mysql", {"host" => $host, "port" => $port}); $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", "joes password", {RaiseError => 1}); # Drop table foo. This may fail, if foo doesnt 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 dont # 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 is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them..

Requirements: No special requirements
Platforms: Linux
Keyword: Admin Database Database Interface Dbd Dbdmysql Dbi Foo Func Host Insert Libraries Perl Module Programming Rc
Users rating: 0/10

License: Freeware Size: 112.64 KB
DBD::MYSQL RELATED
Libraries  -  Class::DBI::ConceptSearch 0.04
Class::DBI::ConceptSearch is a Perl module to retrieve Class::DBI aggregates from high-level conceptual searches. SYNOPSIS my $cs = Class::DBI::ConceptSearch->new(xml => $config); #see CONFIGURATION $cs->use_wildcards(1);...
7.17 KB  
Libraries  -  SQL::Amazon::UserGuide 0.10
SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a...
58.37 KB  
Libraries  -  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 DBI; $driver = "mSQL"; # or "mSQL1"; $dsn = "DBI:$driver:database=$database;host=$hostname"; $dbh =...
194.56 KB  
Libraries  -  DBI::FAQ 1.52
DBI::FAQ is a Perl module for the Frequently Asked Questions of the Perl5 Database Interface. What is DBI, DBperl, Oraperl and *perl? To quote Tim Bunce, the architect and author of DBI: ``DBI is a database access Application Programming...
409.6 KB  
Libraries  -  DBD::MaxDB 7.6.00.27
DBD::MaxDB is a Perl module for MySQL MaxDB database driver for the DBI module version 7.6.0 BUILD 027-121-124-939. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:MaxDB:$hostname/$dbname", "$user", "$password") or die "Cant connect $DBI::err...
87.04 KB  
Libraries  -  DBI 1.57
DBI is a database independent interface for Perl. SYNOPSIS use DBI; @driver_names = DBI->available_drivers; %drivers = DBI->installed_drivers; @data_sources = DBI->data_sources($driver_name, %attr); $dbh = DBI->connect($data_source,...
481.28 KB  
Libraries  -  DBD::Oracle 1.19
DBD::Oracle is a Perl module with Oracle database driver for the DBI module. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd); $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd); # See the...
368.64 KB  
Libraries  -  DBD::Informix 2005.02
DBD::Informix is a Perl module witj IBM Informix Database Driver for Perl DBI. SYNOPSIS use DBI; You should also read the documentation for DBI perldoc DBI as this document qualifies what is stated there. Note that this document was last...
276.48 KB  
Libraries  -  dbitotcl 0.14
dbitotcl is a Tcl extension for using Perl DBI (Database independent interface) from tcl. This project allow to use nearly all functions of Perl DBI from Tcl as new Tcl commands. The use of Perl is hidden from the Tcl-User. Perl is loaded as...
8.19 KB  
Libraries  -  OpenInteract2::Datasource::DBI 1.99_06
OpenInteract2::Datasource::DBI is a Perl module that can create DBI database handles. SYNOPSIS # Define the parameters for a database handle main using PostgreSQL [datasource main] type = DBI dbi_type = Pg dsn = dbname=urkelweb username...
931.84 KB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Libraries  -  wolfSSL 3.15.3
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
3.88 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB