Re: remove gaps in a table
From: mireero <mireero_at_free.fr>
Date: Thu, 21 Dec 2017 01:22:17 +0100
Message-ID: <5a3afeb9$0$20454$426a74cc_at_news.free.fr>
>
> mysql> SELECT T.C + 1 AS FIRSTGAP FROM T LEFT JOIN T AS T1 ON T.C + 1 = T1.C WHERE T1.C IS NULL ORDER BY 1 LIMIT 1;
> +----------+
> | FIRSTGAP |
> +----------+
> | 4 |
> +----------+
> 1 row in set (0.00 sec)
>
Nice ! Received on Thu Dec 21 2017 - 01:22:17 CET
Date: Thu, 21 Dec 2017 01:22:17 +0100
Message-ID: <5a3afeb9$0$20454$426a74cc_at_news.free.fr>
On 12/21/2017 12:53 AM, Stefan Ram wrote:
> ram_at_zedat.fu-berlin.de (Stefan Ram) writes:
>> mysql> SELECT C + 1 AS FIRSTGAP FROM T WHERE NOT EXISTS( SELECT D FROM( SELECT C AS D FROM T )AS T1 WHERE C + 1 = D )ORDER BY 1 LIMIT 1;
>
> mysql> SELECT T.C + 1 AS FIRSTGAP FROM T LEFT JOIN T AS T1 ON T.C + 1 = T1.C WHERE T1.C IS NULL ORDER BY 1 LIMIT 1;
> +----------+
> | FIRSTGAP |
> +----------+
> | 4 |
> +----------+
> 1 row in set (0.00 sec)
>
Nice ! Received on Thu Dec 21 2017 - 01:22:17 CET