> I tried the following code:
>
> CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL,
> ..., showIt ENUM('TRUE') DEFAULT ERROR, ...);
>
> and I was surprised to get an '-00-00' as date after doing a
> SELECT. I would like that the table put automatically the today's
> date for
Christian,
a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try
using a TIMESTAMP field instead.
To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition,
i.e. ENUM('ERROR','TRUE')
Hope this helps...
John
On Thursday 08 February 2001 09:09, Christi
