List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 18 2008 4:44pm
Subject:RE: Finding gaps
View as plain text  
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.




Jerry Schwartz

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
Cc: mysql@stripped
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.
> -Stut
> -- 
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe:


See how Windows Mobile brings your life together-at home, work, or on the
go. See Now <> 

Finding gapsJerry Schwartz17 Sep
  • Re: Finding gapsStut17 Sep
    • Re: Finding gapsPeter Brawley17 Sep
      • RE: Finding gapsJerry Schwartz8 Oct
        • Re: Finding gapsGerald L. Clark8 Oct
          • RE: Finding gapsUS Data Export8 Oct
        • Re: Finding gapsPeter Brawley8 Oct
          • RE: Finding gapsUS Data Export9 Oct
            • Re: Finding gapsPeter Brawley9 Oct
              • RE: Finding gapsJerry Schwartz10 Oct
                • Re: Finding gapsMoon's Father25 Oct
                  • Re: Finding gapsMoon's Father25 Oct
                  • RE: Finding gapsUS Data Export27 Oct
    • RE: Finding gapsJerry Schwartz17 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep
        • RE: Finding gapsJerry Schwartz18 Sep
          • Re: Finding gapsMike Diehl18 Sep
            • RE: Finding gapsJerry Schwartz18 Sep
    • RE: Finding gapsMartin Gainty18 Sep
      • RE: Finding gapsJerry Schwartz18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep