But timestamp type will change on every update. I only want the default value to be the current time/date when the row is inserted and then not change.
>From: Georg Richter <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED], "Shawn Poulson" <[EMAIL PROTECTED]>, >[EMAIL PROTECTED] >Subject: Re: Default created date field >Date: Mon, 15 Jul 2002 17:56:18 +0200 > >On Monday, 15. July 2002 16:51, Shawn Poulson wrote: > >Hi, > > > I'm having trouble doing this in MySQL, but it keeps complaining. All I > > have to work on is: > > create table mytable ( > > createddate datetime not null default now() > > ) > > > >Just use timestamp instead datetime. > >Regards > >Georg > >mysql,query --- Shawn Poulson [EMAIL PROTECTED] _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php