MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: New idea for hierarchy in MySQL
Posted by: Peter Brawley
Date: September 26, 2018 08:49AM

"sa ge",

> The new column `hierarchy` will contains a reference to all parents of this record.

Read about Tropashko's <i>materialised path</i> method.

In addition to 8.0's CTEs, see http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html for a summary for ways to compute hierarchies in MySQL.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
New idea for hierarchy in MySQL
sa ge
September 25, 2018 10:05PM
Re: New idea for hierarchy in MySQL
Edwin Desouza
September 25, 2018 10:25PM
Re: New idea for hierarchy in MySQL
Peter Brawley
September 26, 2018 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.