On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia <[EMAIL PROTECTED]> wrote:
> http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html > > mysql> *ALTER TABLE tbl AUTO_INCREMENT = 100;* > > > > On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain <[EMAIL PROTECTED]> wrote: > >> Hello friends, >> I need to reset auto increment to a lesser value, is there a metod to do >> so >> in any version of mysql. >> Pl. help me. >> Thanks >> abhi >> > > Hi Nacho, Thanks for the reply, But as per a thread on this link, if the resetted value is less than the highest value already in table then the effective increment value will start from highest number and not from 100. I have deleted some rows and i want the increment to start from those row-ids. Pl. reply, Thanks, Abhi
