Mysql auto_increment lower than highest ID

Submitted by Anonymous (not verified) on Thu, 03/18/2010 - 11:40

I am developing an international news-magazine site. I must migrate nearly 50 old news to. I have added 10 old news to test and decide to add old news later. Therefore I have changed auto_increment value from 15 to 100 to keep IDs between 15-100 empty & reserved for old news. I have added some new content and now I have time to add old content. But now when I try to change the auto_increment value from 137 to 15 over phpmyadmin I get see still 137 as last auto increment id. How to go down for autoincrement number?

Add new comment