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
>
