Re: How to insert sequential number in primary row

[Barry Galbraith]

The function of AUTO_INCREMENT is to provide a garunteed unique value for a PRIMARY KEY.
If you want sequential values, then you will have to provide them yourself.
If you stop and think about it, you don't want to change the primary key value on pre-existing rows. That would break any association you have with data in another table using the PRIMARY KEY as a FOREIGN KEY.

Good luck,
Barry.