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