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

On 6/26/2013 1:30 PM, Tedd Sperling wrote:

On Jun 26, 2013, at 1:13 PM, Stuart Dallas <stuart@3ft9.com> 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@sperling.com 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?