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
16185
July 20, 2004 04:18AM
8628
July 20, 2004 11:05AM
7589
July 21, 2004 12:06AM
Re: Create view with MySQL 4.1.20
9278
July 21, 2004 03:12AM
5805
July 22, 2004 02:59AM
5312
July 22, 2004 05:22AM
6798
July 22, 2004 05:42AM
5486
July 22, 2004 06:16AM
5887
July 22, 2004 07:14AM
5568
July 22, 2004 08:03AM
4251
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.