Re: remove gaps in a table
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 20 Dec 2017 23:53:03 GMT
Message-ID: <FIRSTGAP-20171221005228_at_ram.dialup.fu-berlin.de>
Date: 20 Dec 2017 23:53:03 GMT
Message-ID: <FIRSTGAP-20171221005228_at_ram.dialup.fu-berlin.de>
[Quoted] 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;
[Quoted] 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)
Received on Thu Dec 21 2017 - 00:53:03 CET