Re: Default current date

2002-04-25 Thread Victoria Reznichenko
Harpreet, Thursday, April 25, 2002, 4:04:27 AM, you wrote: HK> How can i set the default values of a datetime field in a mysql table as the HK> current date. HK> I am trying HK> alter table copy_tbl add create_date datetime default now() but it does not HK> work. It should not work ... Take a

Default current date

2002-04-24 Thread Harpreet Kaur
How can i set the default values of a datetime field in a mysql table as the current date. I am trying alter table copy_tbl add create_date datetime default now() but it does not work. Please help. Regards, Harpreet Kaur _ MSN