pedrobcabral Posted March 19, 2007 Share Posted March 19, 2007 I have a table where ID is 31 for instance. I add a new entry, is there any option to the phpMyAdmin automaticly go back to fill the empty id spaces? imagine i have missing the number id 2 and 3. Then my submit should go for the number 29. Any automation for this? Than you. Quote Link to comment Share on other sites More sharing options...
paul2463 Posted March 19, 2007 Share Posted March 19, 2007 no there isn't. Not without losing all the other information in the table, the ID value is generally auto incremented to prevent duplication Quote Link to comment Share on other sites More sharing options...
artacus Posted March 19, 2007 Share Posted March 19, 2007 Woohoo! I saw the post subject and said, here's our weekly "how do I sodomize my primary key" post. I love it! And we met our quota early this week! Quote Link to comment Share on other sites More sharing options...
pedrobcabral Posted March 19, 2007 Author Share Posted March 19, 2007 Guess you were the one who was pondering what I was pondering. Ahahah, anyway thanks for your help. 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.