Back

Explore Courses Blog Tutorials Interview Questions
+2 votes
1 view
in SQL by (47.6k points)

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

1 Answer

+4 votes
by (40.4k points)
edited by

Try this code:

ALTER TABLE Table_Name AUTO_INCREMENT=1

Want to learn SQL from basics! Here's the right video for you on SQL provided by Intellipaat:

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...