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