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:[EMAIL PROTECTED] > >Sent: Wednesday, September 17, 2008 6:30 PM > >To: Jerry Schwartz > >Cc: mysql@lists.mysql.com > >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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]