MySQL only supports constant default values. You'll have to insert
the date explicitly when you create the record if you want to simulate
initialization to now().
Timestamps will update themselves whenever any other field in the
record changes, unless you explictly tell them not to. So they are
often not an acceptible substitute for initializing a field with the
current date.
--Pete
> Use the timestamp datatype, not date.
>
> At 02:43 PM 1/15/2001 -0600, Apolinaras \"Apollo\" Sinkevicius wrote:
> >I would like to set a default value in DATE type column to Date(), but it
---------------------------------------------------------------------
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
