my $queryID = "select id, name from studentTable";
my $sth_queryID = $dbh->prepare($queryID);
$sth_queryID->execute();

my @studentInfo;
while (my @row = $sth_queryID->fetchrow){
   push @studentInfo, @row;
}

$sth_queryID->finish;