Is it possible to reset AUTO_INCREMENT in MySQL?

I need to reset AUTO_INCREMENT column in one of the MySQL tables. Is it possible? If so, please let me know how to do it.

Comments

  • This is possible.
    ALTER TABLE tablename AUTO_INCREMENT = 5

    But this doesn't work in InnoDB since it is not allowed.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion