ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment PRIMARY KEY;

ή

ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment, ADD PRIMARY KEY (id);

 

ALTER TABLE table DROP COLUMN id

#unique #auto_increment