Change an autoincrementing field to one previous
Posted
by jlan
on Stack Overflow
See other posts from Stack Overflow
or by jlan
Published on 2010-03-14T12:02:48Z
Indexed on
2010/03/14
12:05 UTC
Read the original article
Hit count: 209
One day, wordpress suddenly jumped from pots id 9110 to 890000000 post.
Days later I'd like to move back new posts to continue from id 9111.
I'm sure that id will never reach id 890000000, no problem here, but id is an autoincrement field and "ALTER TABLE wp8_posts
AUTO_INCREMENT =9111" is not working.
Can I force id to continue from 9111 ?
© Stack Overflow or respective owner