用perl如何访问mysql数据库？

  mysql> create database mydata;

Query OK, 1 row affected (0perl exe 。00 sec)

mysql> use mydata;

Database changed

mysql> create table address (

-> id int(5) not null,

-> name varchar(40) not null,

-> email varchar(50) not null,

-> telephone int(12) null);

Query OK, 0 rows affected (0perl exe 。

  05 sec)

mysql> insert into address values (

-> 1,’Nighthawk’,’nighthawk@ ’, );

Query OK, 1 row affected (0perl exe 。00 sec)

use DBI;

#连接数据库mydata

my $dbh = DBI->connect(’DBI:mysql:mydata’) or die "无法连接数据库: " perl exe 。

   DBI->errstr;

print "插入若干记录n";

my $sth = $dbh->prepare(q{

INSERT INTO address (id, name,email,telephone) VALUES (?, ?, ?, ?)

print "输入记录,回车结束:";

while ($inputdata =) {

chop $inputdata;

last unless($inputdata);

my ($id, $name,$email, $tel) = split( /,/, $inputdata);

$sth->execute($id, $name, $email,$tel)

# $dbh->commit;

print "下面根据输入的名字打印出EMAIL地址和电话n";

my $sth = $dbh->prepare(’SELECT * FROM address WHERE name=?’)

or die $dbh->errstr;

print "请输入姓名,回车结束:";

while ($inputname =) {

my @data;

chomp $inputname;

last unless($inputname);

$sth->execute($inputname) or die "错误: " perl exe 。

   $sth->errstr;

while (@data = $sth->fetchrow_array()) {

print "Email:$data[2]t Telephone:$data[3]n";

#断开连接

$dbh->disconnect;

perl exe 。