Continuing the series:
What is better to store hierarchical data: nested sets model or adjacency list (parent-child) model?
For detailed explanations of the terms, see the first article in the series:
This is the last article of the series which covers MySQL.
MySQL differs from the other systems, since it
is the only system of the big four that does not support
recursion natively. It has neither recursive
CTE’s nor CONNECT BY
clause, not
even rowset returning functions that help to emulate recursion in
PostgreSQL 8.3.
MySQL supports a thing that all other systems …
[Read more]