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. Quote Link to comment 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 Quote Link to comment 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.?? Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.