[thelist] Q on mySQL defaults...

[Anthony Baratta]

At 07:39 AM 4/8/2004, jsWalter wrote:
>is there a way to have mySQL auto insert the current DATE into a field when
>a record is created, but when it's not updated?

Nope - with mySQL default values of the column must be constants.

http://www.mysql.com/doc/en/CREATE_TABLE.html

"Default values must be constants. This means, for example, that you cannot 
set the default for a date column to be the value of a function such as 
NOW() or CURRENT_DATE."

---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."