MySQL: how to change autoindex?

[Jazztronik]

I had to delete a lot of rows at the end of a table and I'd like to reposition the autoindex just after the last remaining row.

[chazzy]

you mean auto increment?
ALTER TABLE t2 AUTO_INCREMENT = value;

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

[Jazztronik]

Yes, I did. Thank you! :) :)