Only the first timestamp is updated by MYSQL. Create two timestamp
fields. MySQL will maintain the first one. Set timestamp2 to null when
the record is created.
Regards,
Rich
At 10:54 AM 6/27/01 -0500, Pete Harlan wrote:
>TIMESTAMP is not the solution to his problem; he wants the date to
>default to now() when the record is created, not updated.
>
>There's currently no way to do this in MySQL; default values must be
>constants.
>
>--Pete
---------------------------------------------------------------------
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
