my $sth = $dbh2->prepare("INSERT INTO PerlTest (Postcode,street_column,streetCount) VALUES ('',?,0)"); ... $sth->execute($mystreet);