MySQL syntax to generate binary structure

Asked Mar 01 '19 at 09:36

Active Jan 06 '20 at 21:33

Viewed 78 times

I have a table as shown in the image. I want to generate output for the given user like if I select "aswarojgar" then I want to fetch all the user who comes under "aswarojgar"

output example for "aswarojgar"

|---------------------|------------------|
|      email          |     side         |
|---------------------|------------------|
|     Mukesh123       |         left     |
|---------------------|------------------|
|     Poonam123       |         left     |
|---------------------|------------------|
|     Pravin123       |         right    |
|---------------------|------------------|
|     Kamal123        |         left     |
|---------------------|------------------|
|     Babi123         |         right    |
|---------------------|------------------|

i want to create a structure like this

         aswarojgar
          /        \ 
     Mukesh123       
       /      \          
 Poonam123    Pravin123            
  /      \     /      \ 
Kamal123             Babi123

edited Jan 06 '20 at 21:33

Dharman

30,962
25
85
135

asked Mar 01 '19 at 09:36

Shubham Mishra

select email, side from your_tab where not email = "aswarojgar" – Gianmarco Varriale Mar 01 '19 at 09:38
Use sub query to get id of row with email = "aswarojgar" and then get all those whose id is greater than subquery id. – Rohit Dalal Mar 01 '19 at 09:41
you should engineer it more, make a group for members – Gianmarco Varriale Mar 01 '19 at 09:41
it not working . can you suggest SQL syntax. – Shubham Mishra Mar 01 '19 at 09:53
I would suggest you create a column to store the parent_id and then generate SQL procedure based on the child traversal logic – cosmoloc Mar 01 '19 at 10:05
Paul Spiegel, Nick if look carefully both questions is different.if you cant suggest the answer then please don't try to avoid the question. – Shubham Mishra Mar 01 '19 at 10:43

MySQL syntax to generate binary structure

0 Answers0