Hello.
Use such alter statement:
alter table mytable change a a int default '1';
Every thing works fine on the MySQL 5.0.3 (from the latest bk source):
mysql> CREATE TABLE `mytable` (
->
-> `a` int(11) NOT NULL,
->
-> `b` int(11) NOT NULL,
->
-> `c` int(11) default NULL
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
