MySQL Forums
Forum List  »  Other Migration

Re: Create view with MySQL 4.1.20
Posted by: tanja
Date: July 22, 2004 02:59AM

Hi Nick,

the depth 3 is the dependencies between parent_id and child_id.
it's a tree...
So

ch_id p_id
1 0
2 0
3 1
4 3


Then my depth is 0->1->3->4
And I want know the number of this depth to make the loop for step in my program... this depth is different. I should count for different parent_id's the depth...
e.g.
p_id = 1;
my depth is 1->3->4 ... now 2

May be exits another possibility?

Thank
Regards Tanja

Options: ReplyQuote


Subject
Views
Written By
Posted
16365
July 20, 2004 04:18AM
8744
July 20, 2004 11:05AM
7682
July 21, 2004 12:06AM
9370
July 21, 2004 03:12AM
Re: Create view with MySQL 4.1.20
5921
July 22, 2004 02:59AM
5394
July 22, 2004 05:22AM
6882
July 22, 2004 05:42AM
5548
July 22, 2004 06:16AM
6003
July 22, 2004 07:14AM
5635
July 22, 2004 08:03AM
4312
April 22, 2009 02:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.