不行也。。。i use: ALTER TABLE t CHANGE a a numeric(20);
got error: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead..
why? is it because the field 'a' is a primary key?
Why there are two a's there?
You don't need two.
