By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE
CREATE TABLE
INSERT 0 8
| id | item | parent_id | rule |
|---|---|---|---|
| 8 | iphone | 6 | null |
| 6 | touch_screen | 4 | null |
| 4 | mobile | 3 | mobile rules |
SELECT 3
DROP TABLE
CREATE TABLE
INSERT 0 8
| id | item | parent_id | rule |
|---|---|---|---|
| 8 | iphone | 6 | null |
| 6 | touch_screen | 4 | null |
| 4 | mobile | 3 | mobile rules |
SELECT 3