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]