Re: Create Table Syntax for DEFAULT

2001-08-23 Thread Paul DuBois
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

Create Table Syntax for DEFAULT

2001-08-23 Thread Igbar Foosenhopper
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