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