[thelist] Q on mySQL defaults...

Anthony Baratta anthony at baratta.com
Thu Apr 8 10:29:55 CDT 2004

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.


"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 

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list