Re: Ask for help on a mysql problem

[Harald Fuchs]

In article <02d901c4b5d0$a1691520$0a02a8c0@martijn>,
"Martijn Tonies" <m.tonies@stripped> writes:

> That is ONE way to store a tree structure :-)

> Another would be:

> ITEMS
> (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> other stuff)

> ITEM_PARENT
> (ItemID int,
>  ParentID int
> primary key (ItemID, ParentID)
> )


> I prefer the latter.

The latter is not a tree, but a directed graph.