[resolved] sync/re-order post id's? (3 posts)

  1. secondv
    Posted 9 years ago #

    Is it possible to rebuild/update the posts table (and all the relevant tables) to re-order the post id's starting from 1? My post id's have large gaps - I guess it doesn't matter too much to most.. (I use permalinks with no id's) - but it's just my preference to have them all fixed :P

    I'm not familiar enough with wordpress to look into it myself, so trying to see if anyone has a solution.

  2. moshu
    Posted 9 years ago #

    It's not WP. It's the nature of the MySQL database. If you have 100 posts and you delete 99, the next new one will be 101. That's how it works. Don't worry about it, and don't mess around with it: you can easily bork your blog.

  3. Chris_K
    Posted 9 years ago #

    What moshu said!

    Also, be aware that uploaded images "consume" a post id. As do Pages. And drafts.

Topic Closed

This topic has been closed to new replies.

About this Topic