Mysql recursion?

by

It is possible, but you need to change your database structure; once the changes are made, you can retrieve a tree of any depth in one query. The queries are slightly more complex, but it’s still pretty straightforward.

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. MySQL: Alternatives to ORDER BY RAND()
  3. MySQL LIKE IN()?
  4. Auto Increment after delete in MySQL
  5. NULL in MySQL (Performance & Storage)
  6. In MySQL queries, why use join instead of where?
  7. MySQL function to find the number of working days between two dates
  8. MySQL Trigger to prevent INSERT under certain conditions
  9. Stored Procedure with optional “WHERE” parameters
  10. MySQL “between” clause not inclusive?
  11. MySQL syntax for Join Update
  12. SQL – How to transpose?
  13. MySQL remove duplicates from big database quick
  14. mysql, iterate through column names
  15. How to delete from select in MySQL?
  16. How to ORDER BY a SUM() in MySQL?
  17. mySQL Returning the top 5 of each category
  18. SQL SELECT to get the first N positive integers
  19. Sorting string column containing numbers in SQL?
  20. Multiple Ranks in one table
  21. The difference between ‘AND’ and ‘&&’ in SQL
  22. How can I make an average of dates in MySQL?
  23. How to combine aggregate functions in MySQL?
  24. What is the best way to generate ranks in MYSQL?
  25. How do I list all the columns in a table?
  26. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  27. How do I create a table alias in MySQL
  28. MySql bulk load command line tool
  29. ALTER TABLE without locking the table?
  30. MySQL: Typecasting NULL to 0

Leave a Comment