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
_____________________
t...@sperling.com
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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php