MySQL 5.0.2 Default Value

2005-03-09 Thread Jason L. McAffee 
The MySQL manual states that as of MySQL 5.0.2 If the
column cannot take NOT NULL as the value, MySQL defines the column with
no explicit DEFAULT clause.  How are the default values then backed-up?
I did not see any statements defining the default values.  Will I have
to re-create the default values if my database becomes corrupted?  

 

Thank you,

 

Jason McAffee

The Technology Group

Re: MySQL 5.0.2 Default Value

2005-03-09 Thread Paul DuBois 
At 9:08 -0500 3/9/05, Jason L. McAffee wrote:
The MySQL manual states that as of MySQL 5.0.2 If the
column cannot take NOT NULL as the value, MySQL defines the column with
no explicit DEFAULT clause.  How are the default values then backed-up?
I did not see any statements defining the default values.  Will I have
to re-create the default values if my database becomes corrupted?
The statement you quote applies in the absence of an explicit DEFAULT
clause that specifies the default value.  I don't know what it means
to back up a default value or re-create them, but I'll guess that the
answer to your questions is: Include an explicit DEFAULT clause in
your column definitions.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]