phpocean Posted May 21, 2009 Share Posted May 21, 2009 Hello people, Two of my row (10 and 50) has same data, thus I wanted to delete row 50 and have row 51 become 50 and so on. Is there a way for me to re-number (rename) my column id (INT) so that there are no mission row? Better yet, is there a way for me to pull data from the next and previous row instead of having to pull the next and previous row by calling +1 and -1? Thank for all the helps. Quote Link to comment https://forums.phpfreaks.com/topic/159107-how-to-remain-mysql-colume-id-int/ Share on other sites More sharing options...
JonnoTheDev Posted May 21, 2009 Share Posted May 21, 2009 Why would you ever need to do this with a primary key? Quote Link to comment https://forums.phpfreaks.com/topic/159107-how-to-remain-mysql-colume-id-int/#findComment-839123 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.