mysql query select parent-child recursive

Question

I do not know how to select query recursive..

I have table like this:

idmenu   idparent     Title
  1         0         menu_parent1
  2         1         menu_child2
  3         1         menu_child3
  4         0         menu_parent4
  5         4         menu_child5
  6         4         menu_child6

how do the results like this

  idmenu    idparent          Title
  1       menu_parent1     menu_parent1
  2       menu_parent1     menu_child2
  3       menu_parent1     menu_child3
  4       menu_parent4     menu_parent4
  5       menu_parent4     menu_child5
  6       menu_parent4     menu_child6

anyone help me..thanks

Hawk · Accepted Answer · 2013-11-21 04:16:21Z

2

zero doesnt refer to something, can you fix it? the answer may be like this

SELECT aa.idmenu,
       bb.title AS idparent,
       aa.title 
FROM [yourtablename] aa
     LEFT OUTER JOIN [yourtablename] bb 
                  ON aa.idmenu=bb.idmenu

edited Nov 21, 2013 at 4:16

Hawk

5,17014 gold badges55 silver badges78 bronze badges

answered Nov 21, 2013 at 4:09

Agoeng Liu

7123 gold badges10 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ardy Ant Over a year ago

Its 0 to determine the child's parents.. and it only exists in one table..sorry my english is bad

Collectives™ on Stack Overflow

mysql query select parent-child recursive

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related