Re: Reseting the auto-increment number in a MySQL database.
| From: | Matijn Woudt | Date: | Wed, 26 Jun 2013 19:23:38 +0000 |
| Subject: | Re: Reseting the auto-increment number in a MySQL database. | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-321509@lists.php.net to get a copy of this message | ||
On Wed, Jun 26, 2013 at 7:35 PM, Tedd Sperling <tedd.sperling@gmail.com>wrote:
> On Jun 26, 2013, at 1:32 PM, Jim Giner <jim.giner@albanyhandball.com>
> 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
>
> _____________________
> tedd.sperling@gmail.com
> 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