Re: MySQL: placeholders and NULL values

The only time a default value is assigned to a column is when you do not include it in the INSERT statement, like so:

CREATE TABLE t1 (
  int x default 100,
  int y
);

INSERT INTO t1 (y) VALUES (1);

SELECT * FROM t1;
[download]

You get (100, 1) back. If you did INSERT INTO t1 VALUES (NULL, 1), you'll get NULL for x's value.

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

Comment on Re: MySQL: placeholders and NULL values Select or Download Code