Trees and Other Hierarchies in MySQL (Relational/hierarchical data overview)

This is a well done summary that is really appropriate for any RDBMS. More than worthwhile if you deal with hierarchical and relational data.