Introduction Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a re
![Managing Hierarchical Data in MySQL — Mike Hillyer's Personal Webspace](https://cdn-ak-scissors.b.st-hatena.com/image/square/ab79eed0a486d8f96d1bd4f51cf70676256b8160/height=288;version=1;width=512/http%3A%2F%2Fmikehillyer.com%2Fmedia%2F%2Fcategories.png)