Perl-Sensitive Sunglasses | |
PerlMonks |
Re: Retrieving column names from SQL with DBIby jcb (Parson) |
on Sep 28, 2020 at 22:43 UTC ( [id://11122310]=note: print w/replies, xml ) | Need Help?? |
From another perspective, if you need to look up what columns are in a table, you might find the DBI $dbh->table_info method helpful. After gathering a list of available columns, you can build a query with known columns in a known order, or use bind_columns to bind hash values with the column names as keys; the DBI documentation has an example of this in the description for bind_columns.
In Section
Seekers of Perl Wisdom
|
|