my $value = "111";
$dbh->do("insert into foo(id, test) values (8, ?)", undef, $value);