Hierarchical structures in SQL

I wish I read this before... The "id, name, parent_id" way of storing trees in a SQL table is probably the most inneficient way to do it! There is a better way of doing things, and here it is:

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html