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]