Select Code to Download

create table foo (
    bar1 Int
   ,bar2 Int
);

my $sth = $dbh->prepare_cached( "SELECT bar2 FROM foo WHERE bar1 = ?" 
+);

$sth->execute( 2 );

SELECT bar2 FROM foo WHERE bar1 = 2;

SELECT bar2 FROM foo WHERE bar1 = '2';

my $sth = $dbh->prepare_cached( "SELECT bar2 FROM foo WHERE bar1 = ?" 
+);

$sth->bind_param( 1, 2, SQL_INTEGER );

$sth->execute();