> 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.
2) not in "maxdb" mode.
http://www.mysql.com/doc/en/DATETIME.html
> > In a table definition, how do I get a date field to be
> > assigned as DEFAULT the current date?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & 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]
