Re: [PHP] Reseting the auto-increment number in a MySQL database.
[email protected] (Tedd Sperling)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
On Jun 26, 2013, at 1:13 PM, Stuart Dallas <[email protected]> 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 _____________________ [email protected] http://sperling.com