From: Carl Youngblood <carl.youngblood@...>
Date: 2004-07-29T10:41:32+09:00
Subject: Re: Stupid ODBC!

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.

On Thu, 29 Jul 2004 10:29:03 +0900, Sean O'Dell <sean@celsoft.com> wrote:
> On Wednesday 28 July 2004 18:04, Carl Youngblood wrote:
> > Why not take the approach of using a autoid function if you have it
> > but creating an extra table for storing counters if you don't?  This
> > seems like a perfectly acceptable solution.
> 
> If portability is not much of an issue, and the autoid implementation works
> properly (i.e. doesn't just +1 to the highest ID), this should be fine.  If
> you ever expect to port it to other engines, or the autoid is like MySQL's
> is, or at least used to be, autoid is pretty dicey.
> 
>         Sean O'Dell
> 
>