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
16366
July 20, 2004 04:18AM
8745
July 20, 2004 11:05AM
7682
July 21, 2004 12:06AM
Re: Create view with MySQL 4.1.20
9370
July 21, 2004 03:12AM
5922
July 22, 2004 02:59AM
5395
July 22, 2004 05:22AM
6883
July 22, 2004 05:42AM
5549
July 22, 2004 06:16AM
6004
July 22, 2004 07:14AM
5636
July 22, 2004 08:03AM
4313
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.