Perl DBI Programming Reading notes, in the original text see:http://www.ibm.com/developerworks/cn/linux/l-cn-perldbi/In order to communicate with the database, the Perl community developed a unified Database communication interface module: DBI. DBI,
Original DBI module installation Tutorial:
1.Install First, I use mysql for testing. You need to install the mysql database on your machine.Then execute:Gem install mysql
Download ruby-DBI from rubyforge, decompress it, and run the following command
Using DBI to connect to a Microsoft SQL server is a relatively simple task. Rather than go with a simple example, I have chosen to demonstrate not just connectivity, but also error checking.As always, when you want to use a module, you must declare
The most commonly used package for Perl access to a database is DBI, which can be found in www.cpan.org. Also need to install the corresponding database driver package, such as Dbd::mysql, Dbd::oracle, dbd::sybase or DBD::ODBC.First, the basic
Use dbi to connect to the mysql database using perl. By using DBI, Perl can easily connect to the mysql database: the code is as follows: Copy the code as follows :#! BinperluseDBI; # ConnecttotargetDBmy $ dbhDBI-connect (by using DBI, DB can easily
Ruby, as a powerful and flexible programming language, has been used by many programmers. They have gained great benefits in the use process. Today, we will introduce one of the following skills: Ruby's application skills for configuring Mysql DBI.
By using DBI, you can easily connect to the MySQL database using Perl:
The code is as follows:Copy the Code code as follows:#!/bin/perl
Use DBI;
# Connect to Target DBMy $dbh = Dbi->connect ("Dbi:mysql:database=eygle;host=localhost", "username",
Source Text Address: http://blog.csdn.net/like_zhz/article/details/5441946Different relational models of DBI and DBD:##########################################################################The portable DBI Method:Connect establishes a connection
Sometimes perl is required to operate mysql databases, which can be implemented through DBI. For more information, see
Sometimes perl is required to operate mysql databases, which can be implemented through DBI. For more information, see
DBI
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.