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. Read more »