List:General Discussion« Previous MessageNext Message »
From:Jay Miller Date:June 15 1999 2:39pm
Subject:RE: DEFAULT value as DATE
View as plain text  
This cannot be done with MySQL at this time.  Your only choices are to use a
TIMESTAMP (in which case the column will be changed every time the row is
updated), or to manually INSERT the CURDATE().

> -----Original Message-----
> From: PinkeshP@stripped [mailto:PinkeshP@stripped]
> Sent: Tuesday, June 15, 1999 9:35 AM
> To: mysql@stripped
> Subject: DEFAULT value as DATE
>
>
> how can i set a column to have a default value as CURDATE() current date
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5245@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

Thread
DEFAULT value as DATEPinkeshP15 Jun
  • RE: DEFAULT value as DATEJay Miller15 Jun
  • ExportingRoger Smith15 Jun
    • Re: ExportingBen Kirkpatrick15 Jun
    • Re: ExportingDino15 Jun