Altering A MySQL Archive Table Altering A MySQL Archive Table Set AUTO_INCREMENT=0 along with the ALTER statement. 2012-11-08 link
