hierarchical-data
Making a parent-child hierachy of msg records saved into mysql?
How could I store messages data into a database so that I could print it as parent child nodes in an unordered list? Each root node could have 2 child(depth) i.e. like grand father, father, & chil[详细]
2023-01-27 22:47 分类:问答Print hierachical data in a parent child form unordered list php?
I have data in mysql table in a parent child hierarchy like; ---------+-----------+-------------| msg_id| parent_id |msg|[详细]
2023-01-27 21:30 分类:问答Need a better, less memory intensive way to organize an unnested parent->child array
I\'ve been using a function I made when I first started programming (Or shortly thereafter at least) to do the simple but extremely useful task of organizing an array based on parents and children. An[详细]
2023-01-26 18:05 分类:问答Database design help - hierarchical data
So I have a table of user accounts (Users). There needs to be functionality in place for subaccounts.[详细]
2023-01-26 13:49 分类:问答Recursive PHP function for adjacency-list display
I have a DB like so: idtextparent 1Parent 10 2Child of 11 3Sibling1 4Another Parent0 5A first child4 So I\'m trying to capture a tree structure my listing the parents. I\'m aware of the other opti[详细]
2023-01-26 11:41 分类:问答SQL query for parent-child chain
I have a single table that can refer to one other member in the table as a parent.That parent could also refer to one other row as its parent...and so on.[详细]
2023-01-25 00:36 分类:问答Get tree of single item in MySQL hierachircal database
I want to retrieve the path to a single node in a hierachical database where only the parent node ID is stored as a reference. Could someone give me a query or some advice on how to write a query (ide[详细]
2023-01-24 17:25 分类:问答Using LINQ to select hierarchical data?
I have a table in SQL Server that is structured like this: idNameParent ------------ 1foonull 2bar1 3oofnull[详细]
2023-01-23 05:39 分类:问答parsing Hierarchical self-join table by tree level?
I have a self referential category table as you see: I want to parse this table to find out tree level for each category. for example if root node level is 0 开发者_Python百科then CPU and Hard Drive[详细]
2023-01-23 05:01 分类:问答What are the options for storing hierarchical data in a relational database?
Good Overviews Generally speaking, you\'re making a decision between fast read times (for example, nested set) or fast write times (adjacency list). Usually, you end up with a combination of the optio[详细]
2023-01-22 17:03 分类:问答