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 se
Only constant values are allowed as default values. If this is the first
timestamp column it will be updated on insert and with every update.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 5/26/04 8:20 PM
Subject: Defaul of NOW()
I have a field in mysql 4, using InnoDB
Field is
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 00, 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...
>
> AL
I have a field in mysql 4, using InnoDB
Field is timestamp 14 and defualt is set to 00, 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(