How to reset AUTO_INCREMENT in MySQL ?

Monday, February 27, 2017

How to reset AUTO_INCREMENT in MySQL ?


How can we reset the auto-increment of a field in Mysql ?

We can reset the counter with following command :-

ALTER TABLE tablename AUTO_INCREMENT = 1

0 comments:

About This Blog

Lorem Ipsum

  © Copyright 2009 Linux-HelpLine.Blogspot.com

Back to TOP