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