If you update the row with NULL for the TIMESTAMP field it will enter the current date and time.

On Feb 5, 2004, at 7:18 AM, Martijn Tonies wrote:

you can use TIMESTAMP data type, which have default NOW()

Not exactly.


1) TIMESTAMP also updates when you update the row, unless
  you set the column value to its current value.

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to