So tired of searching for this, (I know it's simple, but for some reason I can't seem to keep it in memory. LOL!)
You just deleted all the rows in a table – but when you add new rows – they're still starting where the deleted ones left off.
Run this sql query to reset the autoincrement value:
1 | Scott
Of course TRUNCATE will also delete all your rows if you haven't already. Not good if you don't really want an empty table.
If you just want to change the auto_increment without deleting everything, you can
(where xxx is an integer). Or use the operations page in phpmyadmin (which is what I usually do so I don't have to remember any SQL syntax 
3 | Johanka
Thanks! I wish I had known this earlier.
I wonder, is it possible to edit the ID of several entries in the table en mass? Without having to edit manually one at a time?
4 | Scott Porter
Yeah, it is possible to edit multiple id's if you use phpMyAdmin (have just done so) Select the checkboxes of the rows to be changed, and click on the edit icon at the bottom, just after the last row
5 | Don't Back Down
scriptygoddess
