But how do I initialize the 2 datetime fields? With no DEFAULT, their values are 0000-00-00 00:00:00. Just what I wanted to avoid with TIMESTAMP
Set their value to NOW() if you want the current date/time.
-Simon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]