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. 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? 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
Archived
This topic is now archived and is closed to further replies.