Here is an example of how I might have written that. Note the use of placeholders and that null is null and not the string 'null'.

my $id = $dbh->do("INSERT INTO person (id, first_name, last_name ) val
+ues ( null, ?, ? )", undef, $first, $last);
[download]