|
|
Posted by VAUTHIER Christophe on 05/11/05 19:09
I think it's impossible, you have to insert the date each time you write
into your DB. Cf. MySQL Ref Manual:
"
the DEFAULT clause specifies a default value for a column. With one
exception, the default value must be a constant; it cannot be a function or
an expression. This means, for example, that you cannot set the default for
a date column to be the value of a function such as NOW() or CURRENT_DATE.
The exception is that you can specify CURRENT_TIMESTAMP as the default for a
TIMESTAMP column as of MySQL 4.1.2. See Section 11.3.1.2, "TIMESTAMP
Properties as of MySQL 4.1".
"
++
"Rob" <reply@newsgroup.nl> a ιcrit dans le message de news:
d5t77g$drf$1@reader10.wxs.nl...
> Hello all
>
> I have a field (called active) of type DATE and I want to add a default
> value. The default value must be the current date. Is this possible to do
> this in the table create statement?
>
> CREATE TABLE mytable
> (
> id INTEGER NOT NULL AUTO_INCREMENT,
> active DATE DEFAULT ?????,
> PRIMARY KEY (id),
> )
>
> Thanks in advance
> Roger
>
>
>
[Back to original message]
|