From: Carl Youngblood <carl.youngblood@...>
Date: 2004-07-30T03:04:14+09:00
Subject: Re: Stupid ODBC!

Yes.  I did this exact test a couple of years ago and it just keeps
incrementing.  I think the only time it resets its counter is if you
do a truncate or something like that.

On Thu, 29 Jul 2004 11:09:45 +0900, Sean O'Dell <sean@celsoft.com> wrote:
> On Wednesday 28 July 2004 18:41, Carl Youngblood wrote:
> > MySQL has an internal counter variable for every table that never gets
> > decremented.  It does not take the highest existing ID.  AFAIK it
> > hasn't done this for years.
> 
> Are you positive?
> 
> If you create a record with an autoid field, and it gets a value of 20, then
> delete that record, then create another one, you're sure it won't get a value
> of 20?
> 
>         Sean O'Dell