Re: Create view with MySQL 4.1.20
Hi Tanja,
I'm still not absolutely sure what you need to calculate. Do you need to count how many rows there are where child_id = parent_id, or is it that you need to know how many unique parent_ids there are, or something else?
You say that your example would give a depth of 3 - can you describe what the 3 represents from your sample data.
Cheers,
--
Nick Roper
Subject
Views
Written By
Posted
16496
July 20, 2004 04:18AM
8802
July 20, 2004 11:05AM
7734
July 21, 2004 12:06AM
Re: Create view with MySQL 4.1.20
9423
July 21, 2004 03:12AM
5994
July 22, 2004 02:59AM
5452
July 22, 2004 05:22AM
6939
July 22, 2004 05:42AM
5594
July 22, 2004 06:16AM
6058
July 22, 2004 07:14AM
5687
July 22, 2004 08:03AM
4349
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.