> You can have any number of timestamp columns, but only one of them can > be set to autoupdate. As of 4.1 you are not limited to this being the > 1st one in the table and CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), or > NOW() can be used in the DEFAULT. Read > > http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html > > The DATETIME, DATE, and TIMESTAMP Types > > for MUCH more detail.
Absolutely brilliant document *g* ... So now, it makes a difference if it's the first TIMESTAMP column, if it's running in MaxDB mode, if it has a defaulf of NULL (which will be silently changed), if it has no default, a default of CURRENT_TIMESTAMP, or it matters if there's an ON UPDATE clause... Damn man... The guy who thought this up should be smacked in the head! Seriously, this is where triggers are a thing of beauty :-) With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
