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