Top "Nested-sets" questions

The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases.

MySQL Nested Sets - How to find parent of node?

I have your run of the mill nested set hierarchy type setup with the following columns: table name: myset columns: …

sql mysql hierarchy nested-sets
Move node in nested set

I'd need a MySQL query that moves a node and all its children within a nested set. I found this …

mysql tree hierarchical-data nested-sets
Building hierarchy objects from flat list of parent/child

I have a list of items in a hierarchy, and I'm attempting to parse this list out into an actual …

.net hierarchy mptt nested-sets
Getting a modified preorder tree traversal model (nested set) into a <ul>

I am trying to get my data which is hierarchically set up with a tree traversal model into an < …

php html traversal nested-sets
Searching for the best PHP nested sets class (PEAR class excluded)

I'm looking for a PHP (with MYSQL) nested sets class with all needed functions. For example: createLeftNode, createRightNode,createRootNode, createSubNode,…

php class nested set nested-sets
How do you sort a tree stored using the nested set model?

When I refer to nested set model I mean what is described here. I need to build a new system …

database tree hierarchy nested-sets
How do you convert a parent-child (adjacency) table to a nested set using PHP and MySQL?

I've spent the last few hours trying to find the solution to this question online. I've found plenty of examples …

php mysql nested-sets adjacency-list
Help with writing a SQL query for Nested Sets

I'm storing a tree in a DB using nested sets. The table's fields are id, lft, rgt, and name. Given …

sql nested-sets
How to render all records from a nested set into a real html tree

I'm using the awesome_nested_set plugin in my Rails project. I have two models that look like this (simplified): …

sql ruby-on-rails ruby activerecord nested-sets
Nested sets, php array and transformation

I need to transform my nested sets structure (mysql) into json for this spacetree 1) http://blog.thejit.org/wp-content/jit-1.0…

php arrays nested-sets