How to reset AUTO_INCREMENT in MySQL?

Web Technologies Web Development 2 years ago

0 1 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating
_x000D_ _x000D_ How can I reset the AUTO_INCREMENT of a field? I want it to start counting from 1 again.

Posted on 16 Aug 2022, this text provides information on Web Development related to Web Technologies. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago
_x000D_ You can reset the counter with: ALTER TABLE tablename AUTO_INCREMENT = 1 For InnoDB you cannot set the auto_increment value lower or equal to the highest current index. (quote from ViralPatel): Note that you cannot reset the counter to a value less than or equal to any that have already been used. For MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum plus one. For InnoDB, if the value is less than the current maximum value in the column, no error occurs and the current sequence value is not changed. See How to Reset an MySQL AutoIncrement using a MAX value from another table? on how to dynamically get an acceptable value.
0 views
0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Q

Struggling to grow your email list in 2025? Tried these proven hacks yet?

Digital Marketing 0 Answers
Q

What if losing weight could be as easy as sipping delicious smoothies every day?

Health 0 Answers

Similar Blogs


Unity hosting a custom piece of code on own websit...

_x000D_ _x000D_ I was wondering how would you be able to host an "API" on your own website that you...

Manpreet Singh
2 years ago

I am needing advice on a web bot [on hold]

_x000D_ _x000D_ I want to code a bot that has a GUI or CLI doesn't really matter yet but a GUI would...

Manpreet Singh
2 years ago

date and time picker, that can take a max and min...

_x000D_ _x000D_ I have an issue with scheduling things in a web platform (react.js), and need a date...

Manpreet Singh
2 years ago

Important Web Technologies Links