-----Original Message----- From: Floyd Resler [mailto:fresler@xxxxxxxxxxxxx] Sent: Monday, July 13, 2009 5:41 PM To: cool@xxxxxxxxxxxxxxxx Cc: php-general@xxxxxxxxxxxxx Subject: Re: mod primary key field - newbie question Sounds like you want to set the auto increment. To do that, use this query: alter table `table_name` auto_increment 1; That will reset it to one. Although I've never tried it, I assume you can give it another value. Take care, Floyd On Jul 13, 2009, at 5:35 PM, cool@xxxxxxxxxxxxxxxx wrote: > newbie question ... I have a MySQL table where I want to update > (renumber) the primary numeric key field. > > - I successfully turned field off as a primary key index and UN auto > incremented it > - then created new sequential numbers for it > - then turned back on primary key index and re added auto increment in > > > BUT when I make a new record it does NOT start where new numbers stop > > last is 51 > next should be 52 > > but jumps to 157 > > Q: is there a way to reset the NEXT SERIAL ID NUMBER somewhere? how > do I fix this? > > > -- > Thanks - RevDave > Cool @ hosting4days . com > [db-lists 09] > > > "alter table `table_name` auto_increment 1;" Correct you can give it any value you wish it to start FROM. ie if you pass 51 as the value then the next will be Auto increment value will be 52 __________ Information from ESET Smart Security, version of virus signature database 4240 (20090713) __________ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
