Select Code to Download

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $sth = $dbh->prepare( $stmt );
...

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $results = $dbh->selectall_arrayref( $stmt, undef, $myid );

my $sth = $dbh->prepare_cached( $stmt );