Important - am using MySQL 5.6
I am trying to make a perspective tree view component show a heirarchy of items. I am able to get the first level easy enough, but making the “items” property set to the children seems to be impossible in 5.6. Has anyone done this? I read that I might have to update to MySQL 5.7 for this capability to do stuff with JSON, is that true or is there a way to work around it?
SELECT id as 'data', name as 'label' FROM customers
and that does populate my highest level fine.
But my attempts at doing the customers children whether as a subquery or a join either 1) don’t work at all because of SQL rules or 2) puts the children on the same level as the customers.