Re: Re-Ordering ID

[Jonathan Stephens]

Just drop the auto_increment column and then add a new one using ALTER TABLE:

ALTER TABLE mytable DROP myid;
ALTER TABLE mytable ADD myid INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (myid), AUTO_INCREMENT=1;

http://dev.mysql.com/doc/mysql/en/alter-table.html

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle