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
16504
July 20, 2004 04:18AM
8804
July 20, 2004 11:05AM
7738
July 21, 2004 12:06AM
Re: Create view with MySQL 4.1.20
9426
July 21, 2004 03:12AM
6000
July 22, 2004 02:59AM
5452
July 22, 2004 05:22AM
6955
July 22, 2004 05:42AM
5601
July 22, 2004 06:16AM
6061
July 22, 2004 07:14AM
5691
July 22, 2004 08:03AM
4352
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.