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

1 Comment to “Multi level hierarchy in MySQL”

  1. By Sasas, March 21, 2011 @ 11:23 am

    just to let you know that it wasnt henry shakespeare who was father of william shakespeare but was john shakespeare who was the farther of him just to let you know.

RSS feed for comments on this post. TrackBack URI

Leave a Reply