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,
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
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
DBI is a module of the Perl script connection database.Perl scripts are more flexible, more powerful, and cross-platform than the shell. The relative executable jar package is much simpler.? 1, download the installation packageDbi-1.631.tar.gzperl
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
DBI installation: DBI detailed information reference: http://dbi.perl.org/
1. Download the DBI package:Wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.620.tar.gz
2. Decompress
Tar xzf DBI-1.620.tar.gz
3. Enter the decompression package,
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 @
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
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.