When I run the code below, information about the first column in each
table in my list is excluded. Any ideas why?
@table_listing=`cat /usr/local/file.txt`; # contains table list used
below
$dbh =
DBI->connect("dbi:mysql:database=dbname;host=hostIP;port=port_number",
"user", "password") or dienice("Can't connect: $DBI:errstr");
foreach $table (@table_listing){
chomp $table;
print "~~~~~~~~~~~~~~~~~~ $table Table ~~~~~~~~~~~~~~~~~\n";
$statement="explain $table";
$sth = $dbh->prepare($statement) or dienice("Can't prepare
statement: ",$dbh-errstr);
$dbh->errstr;
$sth->execute;
@row_ary = $sth->fetchrow_array;
while (($expl0,$expl1,$expl2) = $sth->fetchrow_array){
print "$expl0 ....... $expl1 ....... $expl2\n";
}
$sth->finish;
print "\n";
}
$dbh->disconnect;
-Brian
sql, query, mysql, database
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
