In the oracle we had the option to populate the records in tree structure manner using the connect by prior clause , Is it possible to achieve the same using the MySql 6.0.6 or else we will define only the stored procedures or will MySql have any reserved functions.
Example :
RootA - SubRootA - SubRootAA - SubRootB - SubRootBB - SubRootC - SubRootCC . It is going dynamic. Please respond as soon as possible.