Select Code to Download

select ? from ... where ..

#!/usr/bin/perl

...
my $sth=$dbh->prepare('select ? as answer');
$sth->execute(42);
$sth->dump_results();

'42'
1 rows

#!/usr/bin/perl

...
$sth->bind_param(1,42,SQL_INTEGER);
$sth->execute();
$sth->dump_results();

42
1 rows