Create the column as a timestamp and the column will be updated on insert and update.
-----Original Message----- From: Mikel - [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:17 AM To: [EMAIL PROTECTED] Subject: table creation Hello list: Is it possible to create a table with a date column with current date as is default value?, like curdate() or now() values?, any ideas. - MySQL 3.23.58-Max-log - RH. 7.3 Greetings and thanks in advanced Mikel _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]