List:General Discussion« Previous MessageNext Message »
From:Scott Plumlee Date:May 27 2004 3:02pm
Subject:Re: Defaul of NOW()
View as plain text  
I didn't think you could have a DEFAULT of NOW() because it's not a true 
static value.  Seems I read that in one of Paul DuBois' books.

Jim Winstead wrote:

> On Wed, May 26, 2004 at 06:20:22PM -0700, Scott Haneda wrote:
> 
>>I have a field in mysql 4, using InnoDB
>>Field is timestamp 14 and defualt is set to 00000000000000, which I want to
>>be the result of NOW() so that every record made will get NOW() as the
>>value, I can not get it to work...
>>
>>ALTER TABLE `addresses` CHANGE `added` `added` TIMESTAMP( 14 ) DEFAULT
>>'NOW()';
>>Query OK, 2 rows affected (0.01 sec)
>>Records: 2  Duplicates: 0  Warnings: 0
>>
>>It tells me it worked, but then it reverts back to the zero's.
> 
> 
> If you do a SHOW CREATE TABLE on the table, you'll see that it has
> actually ignored your DEFAULT. (What is has done is actually transformed
> it to '00000000000000', since that is what the string 'NOW()' becomes
> when you convert it to a TIMESTAMP.)
> 
> Read this section in the manual for information on how the default value
> for TIMESTAMP columns is handled:
> 
>   http://dev.mysql.com/doc/mysql/en/TIMESTAMP_pre-4.1.html
> 
> Support for specifying how TIMESTAMP columns get updated is coming in
> 4.1.2. Right now, it is only documented in the change notes:
> 
>   http://dev.mysql.com/doc/mysql/en/News-4.1.2.html
> 
> Jim Winstead
> MySQL AB
> 


-- 

Scott Plumlee
PGP Public key: http://plumlee.org/pgp/   D64C 47D9 B855 5829 D22A  D390 
F8E2 9B58 9CBF 1F8D
Thread
Defaul of NOW()Scott Haneda27 May
  • Re: Defaul of NOW()Jim Winstead27 May
    • Re: Defaul of NOW()Scott Plumlee27 May
RE: Defaul of NOW()Victor Pendleton27 May