Using MySQL query to traverse rows to make a recursive tree

by

Back in October 24, 2011, someone posted a question in the DBA StackExchange about tree traversal in MySQL. The SQL for MySQL cannot support it.

I wrote up three(3) Stored Procedures (GetParentIDByID, GetAncestry and GetFamilyTree) in my answer to that question. Hope this information helps you construct what you are looking for.

More Related Contents:

  1. mysql stored procedure that calls itself recursively
  2. MySQL – Recursing a tree structure
  3. get a recursive parent list
  4. How to store Emoji Character in MySQL Database
  5. MySQL: Quick breakdown of the types of joins [duplicate]
  6. Any way to select without causing locking in MySQL?
  7. Log all queries in mysql
  8. Truncate all tables in a MySQL database in one command?
  9. Cast from VARCHAR to INT – MySQL
  10. SELECT * FROM multiple tables. MySQL
  11. How to get the difference between two timestamps in seconds
  12. INSERT INTO…SELECT for all MySQL columns
  13. MySQL: Select top n max values?
  14. MySQL search in comma list [duplicate]
  15. What is MySQL’s default ON DELETE behavior?
  16. How do I setup ASP.NET MVC 2 with MySQL?
  17. mysql DECLARE WHILE outside stored procedure how?
  18. SELECT query return 1 row from each group
  19. MySql Single Table, Select last 7 days and include empty rows
  20. How can I check MySQL engine type for a specific table?
  21. mysql SQL: specific item to be first and then to sort the rest of the items
  22. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  23. Where does MySQL store database files on Windows and what are the names of the files?
  24. When is a timestamp (auto) updated?
  25. Should I normalize my DB or not?
  26. MySQL GROUP BY age range including null ranges
  27. MySQL update statement to store ranking positions
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment