Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Recursive with path

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 14, absolute service time: 0,17 sec 
edit mode |  history
   path id parent_id description
1 root 1 NULL 1 Root
2 root/2 2 1 1.1 Group
3 root/2/4 4 2 1.1.1 Group
4 root/2/4/8 8 4 1.1.1.1 Items
5 root/2/4/9 9 4 1.1.1.2 Items
6 root/2/5 5 2 1.1.2 Group
7 root/2/5/10 10 5 1.1.2.1 Items
8 root/2/5/11 11 5 1.1.2.2 Items
9 root/3 3 1 1.2 Group
10 root/3/6 6 3 1.2.1 Group
11 root/3/6/12 12 6 1.2.1.1 Items
12 root/3/6/13 13 6 1.2.1.2 Items
13 root/3/7 7 3 1.2.2 Group
14 root/3/7/14 14 7 1.2.2.1 Items