Is it possible to reset AUTO_INCREMENT in MySQL? - Programmers Heaven

Howdy, Stranger!

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

Categories

Is it possible to reset AUTO_INCREMENT in MySQL?

Jeson84Jeson84 USAPosts: 90Member

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.

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    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.