Alter statement doesn't work in 5.0.2

2005-03-14 Thread Jason L. McAffee
I am using MySQL 5.0.2 on a Redhat 9 box. I am having problems altering some columns default value and having it show up in the 'show create table x' and backup files. Here is my repeatable example: I issue this create statement: create table mytable ( a int not null, b int not null, c in

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