Re: [PHP] Reseting the auto-increment number in a MySQL database.
[email protected] (Matijn Woudt)
| Newsgroups | php.general |
|---|---|
| Message-ID | <CAC_gtuMqU7zH0ge2pw74oCs0cKw-8hSUyFLCPRzGK-s5tKkXXA@mail.gmail.com> |
On Wed, Jun 26, 2013 at 7:35 PM, Tedd Sperling <[email protected]>wrote: > On Jun 26, 2013, at 1:32 PM, Jim Giner <[email protected]> > wrote: > > >> But more importantly - don't you need to figure out why it happened?? > As well as correcting any inserts with the bogus id? > > > Yes, I would like to know -- I'm open for suggestions. > > Cheers, > > tedd > > _____________________ > [email protected] > http://sperling.com > > What storage engine are you using? InnoDB is known for it's auto increment holes, but I didn't expect the holes to be that big. - Matijn