in reply to Re: SQL Insert with blank in the middle
in thread SQL Insert with blank in the middle

$dbh2->do("INSERT INTO PerlTest (Postcode,$_,streetCount) VALUES ('',$ +_,0)");

I think '$_' value is 'Place' and the datatype is 'varchar'.

While use a varchar values in 'values' block, the value must be in between single quote. try the below code.

$dbh2->do("INSERT INTO PerlTest (Postcode,$_,streetCount) VALUES ('',' +\$_\',0)");