Questions tagged [materialized-path-pattern]

46 questions
-1
votes
3 answers

how to create tree view in mysql using stored procedure

I am confused. I don't know how to create a tree view in MySQL using stored procedure. I tried searching in Google and I don't understand how to query. I have deptid | dept_code | dept_name | parent_deptid 1 1 wadir Umum …
1 2 3
4