;
Sent: Friday, May 31, 2002 6:07 PM
Subject: RE: Finding holes in autoinc sequences
> Richard,
>
> Say, that's really good!
> I'm still not used to taking advantage of those variables. Clever.
> Also, I think you can remove all but the rows showing gaps by adding a
gr
,
@flag:=IF(@b=id,id,"MISSING")
from seq
group by id
having id <> range;
> -Original Message-
> From: Richard Clarke [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 7:48 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Finding holes in autoinc sequences
>
>
TECTED]>
To: "'mos'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 10:56 PM
Subject: RE: Finding holes in autoinc sequences
> A simple and fast way to find the gaps is to use a self LEFT JOIN, such
as:
>
> select a.id from seq a
ailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: Finding holes in autoinc sequences
>
>
> I'm going to be tackling this problem in a few days and I
> wanted to bounce
> it off of a few MySQL heads first to see if it g
On Thu, May 30, 2002 at 03:17:53PM -0500, mos wrote:
> I'm going to be tackling this problem in a few days and I wanted to bounce
> it off of a few MySQL heads first to see if it generates any ideas. (or
> sparks?)
>
> Here's is the problem. I have an auto-inc column and rows will get deleted
I'm going to be tackling this problem in a few days and I wanted to bounce
it off of a few MySQL heads first to see if it generates any ideas. (or
sparks?)
Here's is the problem. I have an auto-inc column and rows will get deleted
from the table and of course it will create a hole in the seque
