Home › Forums › Back End › Reset ID(int) to last + 1? › Re: Reset ID(int) to last + 1?
February 2, 2012 at 1:53 pm #96014
I am sure this could probably be simplified into a single query along the lines of
ALTER TABLE imgtable AUTO_INCREMENT = (( SELECT MAX(id) FROM imgtable ) + 1 )
but that is even more untested and off the top of my head ;)