Auto-increment will not touch any rows below the last increment. Any rows it has already incrented to would never be rassigned. That's not how auto-increment works. It might have bothered you for unknown reasons but it would not have hurt anything leaving it was it was. I have over 1670 quotes in my quotes table and the increment is now at 2,000 and something. And it works like it should. The missing rows do nothing.
|