Mahara

  1. Bug #1427885
  2. Comment #4

Comment 4 for bug 1427885

Revision history for this message
Robert Lyon (robertl-9) wrote :

I see that 'WITH RECURSIVE' looks like it's going to be added to mysql 8.0
https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions-recursive

But until then a stored procedure would be needed
https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query