ALTER TABLE
Date: 06/06/05
(MySQL Communtiy) Keywords: mysql, sql
mysql> ALTER TABLE a CHANGE id id1 int(11);
ERROR 1171: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
Column "id" is PRIMARY KEY, AUTOINCREMENT. How can I rename it?
Source: http://www.livejournal.com/community/mysql/58653.html