in reply to Retrieving column names from SQL with DBI
If you use a hashref as the slice arg to fetchall_arrayref you will receive an AoH rather than an AoA. Then it becomes trivial:
my $query = $connect->prepare ("SELECT * FROM TableName"); $query->execute (); my $data = $query->fetchall_arrayref ({}); for my $row (@$data) { for my $key (keys %$row) { print "Column name is $key, column value is $row->{$key}\n"; } }
🦛
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Retrieving column names from SQL with DBI
by Tux (Canon) on Sep 25, 2020 at 09:16 UTC | |
Re^2: Retrieving column names from SQL with DBI
by Krillian (Acolyte) on Sep 25, 2020 at 18:42 UTC |
In Section
Seekers of Perl Wisdom