Adjacency list tree on MySQL
sebetulnya ini kupipas dari blog sayah *hayoo tebak blog saya apa coba..* berhubung dari kemaren dikejar2 si “luffy” untuk posting,apa boleh buat… *huh!*
Modelling hierarchy data in relational database is hard.
Adjacency list is one of few method to modelling this data to SQL.
if you do not know about adjacency list, or you want to know other method than adjacency list, you might wanto to read Joe Celko’s Trees and Hierarchies in SQL for Smarties
Adjacency list is known with its “easy to insert but hard to retrieve”.
