Managing Trees in MySQL Using the Adjacency List Model

Trees and hierarchies can be found everywhere. In our computers’ filesystem, in online shops’ product hierarchies, in the organizational structure of a company, in blog categories, in family trees, the structure of an html page or in geography tables managing the relation between continents, countries cities.

In this article I will describe managing those type of data structure in MySQL using the Adjacency List Model.

Continue reading Managing Trees in MySQL Using the Adjacency List Model