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
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
The MySQL Benchmark test Suite Benchmark is used to install the DBI component. Today, we plan to use the MySQL Benchmark Suite to test the insertion performance. The result is incorrect:
The code is as follows:# Explain the environment[Root @
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
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.
Install bitsCN.com on the DBI and DBD-mysql modules
Install the DBI and DBD-mysql modules
I. DBI installation
Wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
Tar-zxvf DBI-1.604.tar.gz
Cd DBI-1.604
Perl Makefile. PL
Make
Make
Today we're going to test the insertion performance with MySQL's own benchmark Suite (Benchmark Suite), resulting in an error:
Copy Code code as follows:
# Let's just tell the environment
[ROOT@BEANVM ~]# Cat/etc/redhat-release
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.