I would like to do a kind of a CTE query like one can do in MS-SQL.
The below data is representing a tree with an id and parent relation.
Code:
id parent type
1 NULL c
2 1 o
3 2 c
4 2 o
5 1 o
6 NULL c
7 6 c
8 7 c
9 7 o
10 NULL c
11 10 c
12 11 o
13 10 o
14 11 o
I want to find out the closed id. It can be himself or the next up in the tree
So when I query or sp...it should look like this.
Code:
id parent type lastclosed
1 NULL c 1
2 1 o 1
3 2 c 3
4 2 o 1
5 1 o 1
6 NULL c 6
7 6 c 7
8 7 c 8
9 7 o 7
10 NULL c 10
11 10 c 11
12 11 o 11
13 10 o 10
14 11 o 11
The query will look through the tree from the bottom to the top, it should set the lastclosed id when it sees a 'c' in the type column.
dBforums
>
CTE parent child in mysql
07-24-09, 05:12
Linear Mode
