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. Link to comment https://forums.phpfreaks.com/topic/43367-solved-id-holes/ 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 Link to comment https://forums.phpfreaks.com/topic/43367-solved-id-holes/#findComment-210619 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! Link to comment https://forums.phpfreaks.com/topic/43367-solved-id-holes/#findComment-210710 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. Link to comment https://forums.phpfreaks.com/topic/43367-solved-id-holes/#findComment-210771 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.