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. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/