Raivo Ratsep

Multi level hierarchy in MySQL

The other day at work I had to set up  and retrieve a hierarchical structure similar to the one shown here on the picture of the Shakespeare’s family tree. While I ended up retrieving it with PHP, I came across this interesting explanation of how to do it with MySQL stored procedures that I wanted to share. So, if you can’t fall asleep at night or are turned on by graph theory, here you go: Displaying Graphs with MySQL