Home > Archive > PHP SQL > May 2005 > Add default value for date field
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Add default value for date field
|
|
|
| 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
| |
| VAUTHIER Christophe 2005-05-11, 3:58 pm |
| 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
>
>
>
| |
|
| On Wed, 11 May 2005 18:09:46 +0200, "VAUTHIER Christophe"
<crashbronx@wanadoo.fr> wrote:
>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...
>
No.
In your insert Query, use the pair of active and curdate()
|
|
|
|
|