From: Dan Nelson
Date: May 26 2003 5:32am
Subject: Re: DEFAULT value for DATETIME field
List-Archive: http://lists.mysql.com/mysql/140746
Message-Id: <20030526053248.GG23237@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 26), Venkata Srinivasa Rao, Yerra said:
> Dear Nelson,
> 
>         TIMESTAMP type field data will be modified whenever the record get 
> updates.
>         I don't want lose the original date & time because I want to keep 
> record create date & time.

Ah. Then you'll have to either insert NOW() into that field when you create
the record, or create two TIMESTAMP fields.  Both will be updated on
insert, but only the first will be updated when the record is modified.

-- 
	Dan Nelson
	dnelson@stripped