my $list = $db->prepare("SELECT * FROM `table`"); $list->execute(); my @array; while ( my $ref = $list->fetchrow_arrayref() ) { push @array,[@$ref]; } foreach (@array) { print @{ $_ },"\n"; } #### my @array; while ( my @arr = $list->fetchrow_array() ) { push @array,\@arr; } foreach (@array) { print @{ $_ },"\n"; }