Consider a row where in we need to auto increment it. So, instead of using any of the algorithms to increase the row count we can use AUTO_INCREMENT. But make sure that the field which you are using for auto increment has to be the PRIMARY KEY.!
Continue Reading