Thread: Database Spawn ID Cleanup
View Single Post
  #2  
Old 10-05-2012, 03:36 PM
Tabasco's Avatar
Tabasco
Discordant
  
Join Date: Sep 2009
Posts: 269
Default
ALTER TABLE <table> AUTO_INCREMENT = 1;

If you're just emptying tables you can also use TRUNCATE <table>
Reply With Quote