On 6/26/2013 1:30 PM, Tedd Sperling wrote:
On Jun 26, 2013, at 1:13 PM, Stuart Dallas <stuart@xxxxxxxx> wrote:
On Wednesday, 26 June 2013 at 18:07, 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;
ALTER TABLE tbl AUTO_INCREMENT = 2301;
-Stuart
Thanks -- I needed confirmation on that.
It is something that i don't want to do.
Cheers,
tedd
_____________________
tedd@xxxxxxxxxxxx
http://sperling.com
But more importantly - don't you need to figure out why it happened??
As well as correcting any inserts with the bogus id?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
