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
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