MySQL – Recursing a tree structure

by

There’s a good-looking article over at mysql.com outlining various ways of managing hierarchical data. I think it provides a full solution to your question, and shows various less simple, but faster approaches (e.g. Nested Sets).

More Related Contents:

  1. Using MySQL query to traverse rows to make a recursive tree
  2. mysql stored procedure that calls itself recursively
  3. get a recursive parent list
  4. MySQL Recursive get all child from parent
  5. MySQL how to fill missing dates in range?
  6. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  7. Why does MYSQL higher LIMIT offset slow the query down?
  8. How to split the name string in mysql?
  9. Normalization in MYSQL
  10. Is there a REAL performance difference between INT and VARCHAR primary keys?
  11. How to set a maximum execution time for a mysql query?
  12. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  13. Getting around MySQL “Can’t reopen table” error
  14. Can’t Create Entity Data Model – using MySql and EF6
  15. In MySQL, can I copy one row to insert into the same table?
  16. How to copy a row and insert in same table with a autoincrement field in MySQL?
  17. MySQL: Cloning a MySQL database on the same MySql instance
  18. MySQL sharding approaches?
  19. access denied for load data infile in MySQL
  20. Can MySQL convert a stored UTC time to local timezone?
  21. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  22. How to migrate SQL Server database to MySQL? [closed]
  23. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  24. how to cast the hexadecimal to varchar(datetime)?
  25. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  26. Postgres LEFT JOIN with WHERE condition
  27. MySQL – Using COUNT(*) in the WHERE clause
  28. How do you force mysql LIKE to be case sensitive? [duplicate]
  29. Delete all rows with timestamp older than x days
  30. In what order are MySQL JOINs evaluated?

Leave a Comment