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]

Reply via email to