How to get array key and value from select in perl via DBI?

Question

Perl

I have been working with perl for the 2nd day, so do not swear, I googled, I really did not understand anything.
There is a code, actually how do I get the key-> value from the array selected from the database, for example $row['name'] == 'name'.

#!/usr/bin/perl
use DBI;
use threads;
use Data::Dumper;
my $ds = 'DBI:mysql:*:localhost';
my $user = 'root';
my $passw = '*';

my $db = DBI->connect($ds, $user, $passw);

my $res = $db->prepare("SELECT * FROM jobs");


$res->execute();

Answer 1

It can be like this:

my $n = $dbh->prepare('SELECT * FROM `table`  ');
$n->execute();
my $all = $n->fetchall_arrayref( {} );
foreach my $item (@$all) {
    print $item->{'name'};
}

Option from the comments from kloppspb

my $all = $dbh->selectall_arrayref( "SELECT * FROM table ", { Columns => {} } );
for my $item (@$all) {
    print $item->{'name'};
}

Answer 2

In DBI, there are a lot of methods for selecting from tables, take a look.