By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
| id | category | parent_id |
|---|---|---|
| 1 | electronics | 0 |
| 2 | fashion | 0 |
| 3 | TV | 1 |
| 4 | mobile | 1 |
| 5 | Sony | 3 |
| 6 | power bank | 1 |
| 7 | iphone | 4 |
| id | category | parent_id | path |
|---|---|---|---|
| 1 | electronics | 0 | electronics |
| 2 | fashion | 0 | fashion |
| 3 | TV | 1 | electronics > TV |
| 4 | mobile | 1 | electronics > mobile |
| 6 | power bank | 1 | electronics > power bank |
| 5 | Sony | 3 | electronics > TV > Sony |
| 7 | iphone | 4 | electronics > mobile > iphone |