dropfaith Posted October 24, 2008 Share Posted October 24, 2008 title says it all i just need to reset the auto index Id back to 1 i added some new features to my site and the ids need to be auto incremented along with the article Id so if user does article 1 rating adds an Id of 1 yes i have phpmyadmin cuase currently my article id Is 38 even tho i have no artlcles from all the tests ive done Quote Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/ Share on other sites More sharing options...
otuatail Posted October 24, 2008 Share Posted October 24, 2008 If you are resetting back to 1 then you pribably need an empty table. There would be a problem if the database tried to duplicate an ID. Easyest way for me is to go to phpMyAdmin and when the table is empty go to Operations on the top. You can set the value of one there. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673639 Share on other sites More sharing options...
fenway Posted October 24, 2008 Share Posted October 24, 2008 You don't *need* to at all. Quote Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673782 Share on other sites More sharing options...
nadeemshafi9 Posted October 24, 2008 Share Posted October 24, 2008 i found that emptying the table resets it, or you can take ioff teh auto inc and then re number each one and then turn it back on, but you have to empty it, i do rember seeing a button at some point saying reset on the auto inc Quote Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673797 Share on other sites More sharing options...
dropfaith Posted October 24, 2008 Author Share Posted October 24, 2008 i just ended up starting the auto index at a higher number then my highest result Operations on the top Quote Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673800 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.