c has asked for the wisdom of the Perl Monks concerning the following question:
I did a PM search on a similar title and what came up seemed to be even past what little I know of working with MySQL and DBI.
I am currently using:
## TEST get a list of tables my @tables = $dbh->tables(); for my $i(sort @tables) { print uc $i . "\n\n"; my $sth = $dbh->prepare("LISTFIELDS $i"); $sth->execute; $sth->finish; sleep 1; }
The code seems good up to the point that I try and grab the column names and list them out. Its when I make the $sth execute that it returns empty. I am sure that my table does contain columns. The code I have is almost identical to the example in the MySQL DBD README.
thanks -c
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Getting a list of columns from a MySQL Table
by mp (Deacon) on Jul 22, 2002 at 22:27 UTC | |
by c (Hermit) on Jul 22, 2002 at 22:37 UTC | |
| |
Re: Getting a list of columns from a MySQL Table
by Aristotle (Chancellor) on Jul 23, 2002 at 00:12 UTC | |
Re: Getting a list of columns from a MySQL Table
by Moonie (Friar) on Jul 22, 2002 at 22:38 UTC | |
Re: Getting a list of columns from a MySQL Table
by ehdonhon (Curate) on Jul 23, 2002 at 03:21 UTC | |
Re: Getting a list of columns from a MySQL Table
by seattlejohn (Deacon) on Jul 23, 2002 at 04:59 UTC |
Back to
Seekers of Perl Wisdom