From: Martin Gainty Date: September 17 2008 10:29pm Subject: RE: Finding gaps List-Archive: http://lists.mysql.com/mysql/214548 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_d9b57d2a-ba26-4d04-85ae-5d17718dbdf0_" --_d9b57d2a-ba26-4d04-85ae-5d17718dbdf0_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable 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=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > CC: mysql@stripped > From: stuttle@stripped > To: jschwartz@stripped > Subject: Re: Finding gaps > Date: Wed=2C 17 Sep 2008 22:16:52 +0100 >=20 > On 17 Sep 2008=2C at 22:12=2C Jerry Schwartz wrote: > > I have records that should be sequentially (not auto-increment) =20 > > numbered=2C > > but there are gaps. Is there any elegant way of finding the gaps? >=20 > Why do they need to be sequential? When this requirement comes up it's =20 > usually for illogical reasons. >=20 > -Stut >=20 > --=20 > http://stut.net/ >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 _________________________________________________________________ See how Windows Mobile brings your life together=97at home=2C work=2C or on= the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/= --_d9b57d2a-ba26-4d04-85ae-5d17718dbdf0_--