[size=medium]ALTER TABLE tablename DROP id; ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST[/size]