my $sth = $dbh->prepare(<<SQL);
insert into my_table (id, name) values ('15', 'Foo')
SQL

##</code><code>##

my $sth = $dbh->prepare(<<SQL);
insert into my_table (id, name) values (?, ?)
SQL

##</code><code>##

$sth->execute('15', 'Foo');

##</code><code>##

my $sth = $dbh->prepare_cached(<<SQL);
insert into my_table (id, name) values (?, ?)
SQL
$sth->execute('15', 'Foo');