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. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 6:29 PM To: Stut; Jerry Schwartz Cc: mysql@lists.mysql.com Subject: RE: Finding gaps unless you cant spare a few milliseconds off of each insert.. i strongly suggest to use autoincrement http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Martin ______________________________________________ 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 transmission. > CC: mysql@lists.mysql.com > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > 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. > > -Stut > > -- > http://stut.net/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > _____ 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/>
