Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
I have a content table, each has a primary auto incrementing key called ID. Over time, these values has fragmented. For example, it will go to 187, then skip to 240 and continue, and so on.
What I want to do is where it skips, overwrite 240 and start back at 188 and continue upward correctly. Is there an easy way to do this without manually correcting this?
By the way, the database is MySQL and I am using PHP.
If you aren't using those values anywhere else and just want to reorder them, it should be as simple as removing that column from the table and then re-adding a new auto incrementing column to the table.