List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 18 2008 8:09pm
Subject:RE: Finding gaps
View as plain text  
Alas, the gaps are as large as 500.

Normally, products are never deleted from the system; but I put in some
corrupt data that I did not want to pass along, even if I marked them as
discontinued. They complain about that, too.

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


>-----Original Message-----
>From: Mike Diehl [mailto:mdiehl@stripped]
>Sent: Thursday, September 18, 2008 1:17 PM
>To: mysql@stripped
>Cc: Jerry Schwartz; 'Stut'
>Subject: Re: Finding gaps
>
>Hi all,
>
>I'm just throwing something out ...
>
>How about:
>
>select a.id,b.id from dataset a left join dataset b
>	on a.id=b.id+1
>	where b.id is null;
>
>This should find single gaps.  It won't find larger gaps.
>
>Just my $.02.
>
>Mike.
>
>On Thursday 18 September 2008 10:44:47 am Jerry Schwartz wrote:
>> >-----Original Message-----
>> >From: Stut [mailto:stuttle@stripped]
>> >Sent: Wednesday, September 17, 2008 6:30 PM
>> >To: Jerry Schwartz
>> >Cc: mysql@stripped
>> >Subject: Re: Finding gaps
>> >
>> >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?
>>
>> [JS] In this case, we are dealing with a list of products.
>>
>> >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.
>>
>> [JS] I can pass along my boss's email address, if you want to explain
>to
>> him why it doesn't matter. Personally, I depend upon my job.
>>
>> >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.
>>
>> [JS] They are propagated into other databases that I do not control.
>They
>> are managed and used by our main office in Japan. They notice
>everything
>> (except misspellings).
>
>
>
>--
>Mike Diehl



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