Select Code to Download

SELECT @count := @count+1 as sequence, id, name, filename from mytable

my $query = "SELECT id, name, filename from mytable";
my $sth=$dbh->prepare($query);
...
while (my $row = $sth->fetchrow_arrayref) {
    push @results, [ $count++ , @$row ]
}