You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
558 B
22 lines
558 B
```sql
|
|
WITH RECURSIVE child (id, title, description, parent_id) AS
|
|
(
|
|
SELECT id, title, description, parent_id
|
|
FROM items
|
|
WHERE id = 38
|
|
UNION
|
|
SELECT parent.id, parent.title, parent.description, parent.parent_id
|
|
FROM child JOIN items as parent
|
|
ON child.parent_id = parent.id
|
|
)
|
|
SELECT * FROM child;
|
|
```
|
|
|
|
https://www.mysqltutorial.org/mysql-adjacency-list-tree/
|
|
|
|
## JS Libraries
|
|
|
|
- https://github.com/dbushell/Nestable
|
|
- https://dbushell.github.io/Nestable/
|
|
- https://sortablejs.github.io/Sortable/
|
|
- https://bevacqua.github.io/dragula/ |