清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
#!/usr/bin/perl # ppm install DBD::mysql use DBI; # use strict; my $dbname = "test"; my $location = "localhost"; my $port = "3306"; my $database = "DBI:mysql:$dbname:$location:$port"; my $db_user = "root"; my $db_pass = ""; my $dbh = DBI->connect($database,$db_user,$db_pass); my $sql = "SELECT * FROM y2k"; my $sth = $dbh->prepare($sql); $sth->execute() or die "Cannot execute: $dbh->errstr"; while ( @row = $sth->fetchrow_array ) { print "@row\n"; } #$rows = $dbh->do("INSERT INTO y2k VALUES ('2000-02-28','2000-02-28 00:00:00',20000228000000)") # or die "Couldn't insert record : $DBI::errstr"; #print "$rows row(s) added to y2k\n"; $dbh->disconnect;