Resetting MYSQL Auto increment Haneef Puttur 17 years ago ALTER TABLE theTableInQuestion AUTO_INCREMENT=1 .