0

Anybody please help use the below table and tree structure and calculate left and right count.

My Table Creation Query:

CREATE TABLE testmlm.binary_tree (
id INT( 11 ) NOT NULL AUTO_INCREMENT ,
name VARCHAR( 150 ) NOT NULL ,
left_id INT( 11 ) NULL ,
right_id INT( 11 ) NULL ,
level INT( 6 ) NULL ,
PRIMARY KEY ( id )
) ENGINE = InnoDB;

      Field     Type
     -------       ------
       id          int(11)
       name        varchar(150)
     left_id    int(11)
     right_id   int(11)
      level     int(6)

After inserting Values:

id name left_id right_id level
-- ---- ------- ---------- -----
1 abc 2 3 1
2 def 4 5 2
3 ghi 6 7 2
4 jkl 8 null 3
5 mno null 9 3
6 pqr null null 3
7 stu 10 null 3
8 vwx null null 4
9 yza null null 4
10 bcd null null 4

           My Tree Structure
          -------------------

                id:1
            /         \
          id:2       id:3
        /     \      /     \
     id:4    id:5  id:6    id:7
     /
  id:8          \          / 
                id:9     id:10

I want to create Customer List, and it will generate via MySQL queries like this for all above 10 Ids

                          For ID 1

       Left Side                                  Right Side
  ID             Name                           ID             Name
  2              def                            3               ghi
  4              jkl                            6               pqr
  5              mno                            7               stu
  8              vwx                           10               bcd
  9              yza


                          For ID 2

       Left Side                                  Right Side
  ID             Name                           ID             Name
  4              jkl                            5               mno
  8              vwx                            9               yza


                          For ID 3

       Left Side                                  Right Side
  ID             Name                           ID             Name
  6              pqr                            7               stu
                                                10              bcd


                          For ID 4

       Left Side                                  Right Side
  ID             Name                           ID             Name
  8              vwx


                          For ID 5

       Left Side                                  Right Side
  ID             Name                           ID             Name
                                                9              yza


                          For ID 6

       Left Side                                  Right Side
  ID             Name                           ID             Name


                          For ID 7

       Left Side                                  Right Side
  ID             Name                           ID             Name
  10             bcd


                          For ID 8

       Left Side                                  Right Side
  ID             Name                           ID             Name


                          For ID 9

       Left Side                                  Right Side
  ID             Name                           ID             Name


                          For ID 10

       Left Side                                  Right Side
  ID             Name                           ID             Name

How its possible! Please help me...

2
Contributors
1
Reply
8
Views
3 Years
Discussion Span
Last Post by veedeoo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.