Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* 欠番検索 [#f63c4652]
** 前提 [#x080fc0a]
SELECT * FROM t1;
+------+
| id |
+------+
| 1 |
| 2 |
| 4 |
+------+
3 rows in set (0.00 sec)
3が欠番になっている。
** 欠番検索 [#t75db5a5]
SELECT id + 1 FROM t1 WHERE (id + 1) NOT IN ( SELECT id ...
+--------+
| id + 1 |
+--------+
| 3 |
| 5 |
+--------+
2 rows in set (0.01 sec)
終了行:
* 欠番検索 [#f63c4652]
** 前提 [#x080fc0a]
SELECT * FROM t1;
+------+
| id |
+------+
| 1 |
| 2 |
| 4 |
+------+
3 rows in set (0.00 sec)
3が欠番になっている。
** 欠番検索 [#t75db5a5]
SELECT id + 1 FROM t1 WHERE (id + 1) NOT IN ( SELECT id ...
+--------+
| id + 1 |
+--------+
| 3 |
| 5 |
+--------+
2 rows in set (0.01 sec)
ページ名: