Re: DEFAULT value for DATETIME field

[Dan Nelson]

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