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
16851
July 20, 2004 04:18AM
9001
July 20, 2004 11:05AM
7853
July 21, 2004 12:06AM
Re: Create view with MySQL 4.1.20
9651
July 21, 2004 03:12AM
6141
July 22, 2004 02:59AM
5707
July 22, 2004 05:22AM
7336
July 22, 2004 05:42AM
5919
July 22, 2004 06:16AM
6439
July 22, 2004 07:14AM
5802
July 22, 2004 08:03AM
4444
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.