
#!/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) 回复
??
回复评论