Yes, that would have been a very good idea. I did not design this.
Even if we used auto-increment, my current problem would be the same:
finding gaps in the numbering.
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
From: Martin Gainty [mailto:mgainty@stripped]
Sent: Wednesday, September 17, 2008 6:29 PM
To: Stut; Jerry Schwartz
Subject: RE: Finding gaps
unless you cant spare a few milliseconds off of each insert..
i strongly suggest to use autoincrement
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and Sender
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
> CC: mysql@stripped
> From: stuttle@stripped
> To: jschwartz@stripped
> Subject: Re: Finding gaps
> Date: Wed, 17 Sep 2008 22:16:52 +0100
> On 17 Sep 2008, at 22:12, Jerry Schwartz wrote:
> > I have records that should be sequentially (not auto-increment)
> > numbered,
> > but there are gaps. Is there any elegant way of finding the gaps?
> Why do they need to be sequential? When this requirement comes up it's
> usually for illogical reasons.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
See how Windows Mobile brings your life together-at home, work, or on the
go. See Now <http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/>