How to use perl to connect MySQL?(利用Perl连接MySQL)
来源:互联网 发布:sql连接尝试失败 编辑:程序博客网 时间:2024/06/10 15:43
1. Install MySQL on Windows/Linux
1.1 Windows
1) Download mysql-essential-5.0.86-win32.msi from MySQL "http://dev.mysql.com/downloads/mysql/5.0.html#win32"
2) Click it to install MySQL on windows
1.2 Linux/Solris
1) Download pre compiled binary package from "http://dev.mysql.com/downloads/mysql/5.0.html"
2) Unzip and Untar it to ur Linux/Solris machine.
3) In "mysql-5.1.38-xxxxx-i386/ script s", u can find "mysql_install_db" script . Execute it.
4) Run command "nohup mysql-5.1.38-xxxxx-i386/bin/mysqld --basedir=which u untar the mysql"
2. Install DBD::mysql and DBI modules for ur perl
2.1 Active perl 5.x on Windows
Use ppm tool to search DBD::mysql and DBI then install them.
2.2 Perl 5.x on Linux/Solris
perl -MCPAN -e "install DBI"
perl -MCPAN -e "install DBD::mysql"
3. How to write code to connect and do anything in MySQL against perl
use DBI;
use DBD::mysql;
use strict;
my $db = "mysql";
my $connectionInfo = "DBI:mysql:database=$db;host=localhost";
my $userid = "root";
my $passwd = "123456";
my $dbh = DBI->connect($connectionInfo,$userid,$passwd);
my $sql = 'select User from user';
my $sth = $dbh->prepare($sql);
$sth->execute();
my $rows = $sth->fetchrow_hashref();
$sth->finish();
foreach my $key(keys %$rows)
{
print "$key => $rows->/n";
}
$dbh->disconnect;
- How to use perl to connect MySQL?(利用Perl连接MySQL)
- how to use perl to operate excel
- How to use mysql?
- How to connect Access2007 by DBI in Perl
- How to Connect to MySQL Using C#
- How to use next and last in Perl
- How to debug in Perl ?
- perl与mysql连接
- perl连接查询mysql
- perl 连接 mysql
- Perl连接Mysql
- perl连接mysql
- perl连接MySQL出错
- perl 连接 mysql 数据库
- perl连接mysql
- How To Use MySQL Easily In PHP
- How to use MySql with Linq to SQL
- Perl Module : How to Install Perl Module on Windows
- 循环双向链表及快速排序
- 开始重写网站后台
- C/C++程序员应聘常见面试题深入剖析(2)
- Linux 下tomcat 的安装与设置
- 在ascx中使用DropDownList绑定数据页面刷新时变空的问题
- How to use perl to connect MySQL?(利用Perl连接MySQL)
- evc的Micorsoft ActiveSync同步——备忘
- java 字符编码
- delphi 動態安裝服務
- MyEclipse 快捷键大全
- BCB线程间的同步通信
- 装饰模式的两点解释和vb.net实现
- css hack
- SSO各产品单点登录的简单实现