-----Original Message-----
From: Floyd Resler [mailto:fres...@adex-intl.com] 
Sent: Monday, July 13, 2009 5:41 PM
To: c...@hosting4days.com
Cc: php-general@lists.php.net
Subject: Re: [PHP] mod primary key field - newbie question

Sounds like you want to set the auto increment.  To do that, use this  
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,

On Jul 13, 2009, at 5:35 PM, c...@hosting4days.com 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.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to