Hierachical Order in mysql

Most of my posts are informative, advertisements or purely notes for my convenience, this post falls under the latter.

Hierachical Data in Mysql is just that a blog post by another on the subject of using hierarchy or parent child relationships to control data and the intracacies that come with it.

Just some thoughts to note and add to this rather good article, and to let you know I've trawled a few alternate articles and most neither add to this or give an benefit this article is very well written and provides all you should need to get started using this.

Some more thoughts:
Order may be used to provide simplified SQL in you application over teh full usage of parent/child this is for you to decide.

1.  parent child is complicated and requires a way to distinguish in your application the following:
   
   
   • which are parent
   • which are child
   • how many parent levels
   • current highest right value

This is just my first observations I will possibly add to this later.