From: Peter Brawley
Date: April 20 2007 3:22pm
Subject: Re: Storing forests in tables.
List-Archive: http://lists.mysql.com/mysql/206282
Message-Id: <4628DAC4.5070603@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Nathan,

 >I ve recently been playing with storing trees in mysql using nested
 >set, and I was wondering if anyone knows if this could be extended to
 >forests (set of trees) to be stored in one table?

Dead simple, add a treeID smallint column to the table that holds the 
nested sets, and add ... WHERE treeID = <treeid> ... to every update, 
delete, insert & select.

PB

-----

Nathan Harmston wrote:
> Hi,
>
> I ve recently been playing with storing trees in mysql using nested
> set, and I was wondering if anyone knows if this could be extended to
> forests (set of trees) to be stored in one table?
>
> Many Thanks in advance,
>
> Nathan
>