in reply to Using MySQL table's default values upon insert

my $sth = $dbh->prepare(q[INSERT INTO foo (bar) VALUES(?)];
$sth->execute($bar);

[download]

If you use or die after each statement, you could just as well use the RaiseError => 1 option to DBI's connect.

Perl 6 - links to (nearly) everything that is Perl 6.

In Section Seekers of Perl Wisdom