clonetrooper9494 Posted June 9, 2008 Share Posted June 9, 2008 I am working making a login system and I am making a lot or row and then deleting them to test out how it all works, but when I delet a row and make a new one, the auto_increment ignores the holes, so I have a table saying USERID INFO PASSWORD1 Blah4 WHY DOES IT SKIP10 NEW USERHow do I reset the auto_increment thing, back to 1? Link to comment Share on other sites More sharing options...
Wander Posted June 9, 2008 Share Posted June 9, 2008 ALTER TABLE `table` AUTO_INCREMENT = 1;see: http://dev.mysql.com/doc/refman/5.1/en/exa...-increment.html Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.