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