In article <[EMAIL PROTECTED]>, "Martijn Tonies" <[EMAIL PROTECTED]> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
