# loop through rows
while ($hashref = $sth->fethrow_hashref()) {
   push @$myarrayref , $hashref;
}

##</code><code>##

# loop through rows
while ($hashref = $sth->fetchrow_hashref()) {
   push @$myarrayref , { %$hashref };
}