Tree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions for modeling #hierarchical data that work for #MySQL, including:
* Adjacency List
* Path Enumeration
* Nested Sets
* Closure Table
Code examples will demonstrate using the Closure Table in PHP, and offer guidelines for choosing one design over another.
PRESENTER: Bill Karwin, Principal #MySQL Instructor on February 27, 2011.
[ Ссылка ]
📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.
[ Ссылка ]
Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: [ Ссылка ]
Follow Percona on Facebook: [ Ссылка ]
Follow Percona on Instagram: [ Ссылка ]
Follow Percona on LinkedIn: [ Ссылка ]
![](https://s2.save4k.ru/pic/wuH5OoPC3hA/maxresdefault.jpg)