
#!/usr/bin/perl
use strict;
use DBI;
my $dbh = DBI->connect ( "dbi:mysql:dbname", 'user','passwd', '' )
or die "can't connect!\n";
my $sql = qq/show variables/;
my $sth = $dbh->prepare ( $sql );
$sth->execute();
while ( my @array=$sth->fetchrow_array() )
{
printf ( "%-35s", $_ ) foreach ( @array );
print "\n";
}
$dbh -> disconnect();
exit 0;




by: 发表于:2017-09-11 11:53:10 顶(0) | 踩(0) 回复
??
回复评论