my $sth = $dbh->prepare("insert test(id, name) values(?, ?)");
$sth->execute($id, $name);

##</code><code>##

$id = 'NULL' unless defined($id);
$dbh->do("insert test(id, name) values($id, \"$name\")");