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

Filed under:
|

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

Related posts about mysql

Related posts about sql