How to reset AUTO_INCREMENT in MySQL?

Question

Krishnapriya Rajeev · Answer

To reset the auto_increment value in MySQL, you can use the ALTER TABLE statement with the AUTO_INCREMENT option. Given below is an example:
Let's say you have a table named my_table with an auto_increment column named id. If you want to reset the auto_increment value to start from 1 again, you can use the following SQL statement:
ALTER TABLE my_table AUTO_INCREMENT = 1;
This will set the auto_increment value for the id column to 1, and the next inserted row will have an id value of 1.
If you want to set the auto_increment value to a specific number other than 1, you can replace "1" in the above statement with the desired starting value.

forum

How to reset AUTO_INCREMENT in MySQL?

Revati S Misra

Can you answer this question?

1 Answers

Liked By