Hierarchy 1

[CassidyHunt]

I am fairly new to mysql and more familiar with Oracle. I do not know if this is supported. I didn't find anything on google for this in mysql. I am trying to basically create a tree structure on the database. In Oracle the statement I would use would be:

select unique_id, parent_id, (lpad(' ',(level - 1)*3) || nodetext) as nodetext from table
start with parent_id is null
connect by prior unique_id = parent_id

Thanks

 

[ericbrunson]

MySQL doesn't implement connect by prior.

You might consider using an adjacency model. There's a really good article on adjacencies on the mysql website:

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

 

[CassidyHunt]

Thank you. That should do the trick.