List:General Discussion« Previous MessageNext Message »
From:Stut Date:September 17 2008 10:29pm
Subject:Re: Finding gaps
View as plain text  
On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
> Our Japanese partners will notice and will ask. Similar things have  
> come up
> before.
>
> I want to be pro-active.

Notice what? Why would it be bad? What type of data are we dealing  
with here?

If each row requires a unique ID use an autonumber. If your partners  
don't understand that deleted items will create gaps, explain it to  
them. IMHO you're creating a problem that doesn't exist.

If you just need sequential numbers for display purposes, generate  
them when you do the displaying. There's no need for those numbers to  
be in the database.

-Stut

-- 
http://stut.net/

>> -----Original Message-----
>> From: Stut [mailto:stuttle@stripped]
>> Sent: Wednesday, September 17, 2008 5:17 PM
>> To: Jerry Schwartz
>> Cc: mysql@stripped
>> Subject: Re: Finding gaps
>>
>> 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/
>
>
>

Thread
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