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