Re^2: Using MySQL table's default values upon insert

Select or download this

my $sth = $dbh->prepare('INSERT INTO foo SET '
                            . "bar  = isnull(?, 'default_bar'), '
                            . "blah = isnull(?, 'default_blah')) "

Select or download this

Bareword found where operator expected at line 442, near ". "blah
"
...
        (Missing operator before blah?)
Unquoted string "blah" may clash with future reserved word at line 442
+ (#2)

Select or download this

. "blah = isnull(?, 'default_blah')) "

Select Code to Download