|
|
Posted by tim on 05/12/05 15:20
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...
>> 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
>>
>>
>>
>
No.
In your insert Query, use the pair of active and curdate()
Navigation:
[Reply to this message]
|