in reply to Re^3: MySQL: placeholders and NULL values
in thread MySQL: placeholders and NULL values

Did you miss the question? It asks how to set a column to NULL with placeholders, not set it to the default. NULL may or may not be the default for a column.
  • Comment on Re^4: MySQL: placeholders and NULL values

Replies are listed 'Best First'.
Re^5: MySQL: placeholders and NULL values
by japhy (Canon) on May 03, 2006 at 05:12 UTC
    The OP had this:
    $cols[0] = undef ; # gives default value of that column
    which I have shown to be untrue. Doing that WILL set it to NULL.

    Jeff japhy Pinyan, P.L., P.M., P.O.D, X.S.: Perl, regex, and perl hacker
    How can we ever be the sold short or the cheated, we who for every service have long ago been overpaid? ~~ Meister Eckhart