Re: [PHP] Reseting the auto-increment number in a MySQL database.

On 06/26/2013 10:07 AM, Tedd Sperling wrote:
> Hi gang:
>
> I have a client where their next auto-increment number just jumped from 2300 to 1000000000 for reasons not understood. They want it set back.
>
> Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a relational table thing.
>
> So, is there a way (programmatically) to set the next number in an auto-increment?
>
> Something like:
>
> alter table abc auto_increment = 2301;
>
> Any ideas of why this happened?
>
> Cheers,
>
>
> tedd
>
> _____________________
> [email protected]
> http://sperling.com
>
>


If mysql logging is turned on, you might be able to rummage through the 
logs and see what happened and when it happened.

-- 
Jim Lucas

http://www.cmsws.com/
http://www.cmsws.com/examples/