DEV Community

Diego
Diego

Posted on

Set new number for autoincrement value in a MySQL table

If you want to reset the auto-increment number of a table to start it again with a new value, you have to launch this SQL:

ALTER TABLE my_table_name AUTO_INCREMENT=400;
Enter fullscreen mode Exit fullscreen mode

In this case, 400 is the value you want to be the new start value.

Top comments (0)

Read next

jasminempa profile image

You Are Already Using Wasm In Production

Jasmine Mae -

amitkayal profile image

S3 table & S3 Metadata table

Amit Kayal -

roboword profile image

Requirements Engineering: A Practical Approach from 30 Years of Industry Experience

Taka Saito -

shrsv profile image

For LiveAPI - Each Day In Itself is a Little Life

Shrijith Venkatramana -