At 5:18 PM -0700 8/23/01, Igbar Foosenhopper wrote:
>Is it possible to use current_date (mysql function) to generate a
>default for a column?
No. Defaults must be constants.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
>If so .. what would the syntax look like. I have tried several thing
Is it possible to use current_date (mysql function) to generate a
default for a column?
If so .. what would the syntax look like. I have tried several things
and it doesn't seem to like it.
If not .. how could I generate a default of todays date (of course
dependent on the date of insert)?
Tha