Ninjakreborn Posted August 4, 2006 Share Posted August 4, 2006 I like resetting my database's completely before going live, but I have a question for now. How do I figure out how to reset the id's on my auto-incremented fields. I have 1 auto-incremented id field for almost every table, but I like resetting those id's before everything goes live so that start counting back from one, how do I do this using phpmyadmin. Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/ Share on other sites More sharing options...
cmgmyr Posted August 4, 2006 Share Posted August 4, 2006 If you are using phpMyAdmin all you have to do is "Empty" each table and it will reset it.-Chris Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/#findComment-69220 Share on other sites More sharing options...
Ninjakreborn Posted August 4, 2006 Author Share Posted August 4, 2006 emtpy? if you mean removing everything from the table, I delete it all and it doesn't reset, is there an option called empty, where do I find this.?? Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/#findComment-69228 Share on other sites More sharing options...
Ninjakreborn Posted August 4, 2006 Author Share Posted August 4, 2006 ah, I see that, thank you for the advice, it is appreciated. Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/#findComment-69229 Share on other sites More sharing options...
cmgmyr Posted August 4, 2006 Share Posted August 4, 2006 No problem it should have been a tab up at the top.You can also go into the operations tab and there is a spot where you can change the auto inc number.-Chris Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/#findComment-69230 Share on other sites More sharing options...
fenway Posted August 4, 2006 Share Posted August 4, 2006 "TRUNCATE TABLE" is the MySQL command you seek. Link to comment https://forums.phpfreaks.com/topic/16551-reset-ids/#findComment-69447 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.