MySQL auto_increment index reset

Random Info #3
Thursday, February 20, 2003

Suppose you delete a journal entry and the auto_increment id field in your database is set one too high. Use this:

ALTER TABLE [table_name] AUTO_INCREMENT=1;