Re: DEFAULT value for DATETIME field

[Yerra Venkata Srinivasa Rao]

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.

Best Regards,
Srinivas.
At 12:21 AM 5/26/2003 -0500, Dan Nelson wrote:
>In the last episode (May 26), Venkata Srinivasa Rao, Yerra said:
> > Hi All,
> >
> >         Any body knows how to set system date & time as a default value to
> > a field of type DATETIME while creating the table.
> >
> > CREATE TABLE test(id INT(10), createdate DATETIME DEFAULT ?);
>
>Use a TIMESTAMP field type.
>
>--
>         Dan Nelson
>         dnelson@stripped
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1