If you are looking for ways to retrieve and store hierarchical data (employees and managers, for instance) I'll also recommend looking at the Nested Set hierarchy. Search news groups for it, and look into Joe Celko's book _SQL For Smarties_, which describes the technique. You can store a complete hierarchical tree in mySQL, get the list of managers for an employee (in descending/ascending order) etc.. It's a powerful structure.
I've used it to create powerful structures that operate, with the same SQL, on oracle, mysql, sql server, and others. > -----Original Message----- > From: Knepley, Jim [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 11:35 AM > To: [EMAIL PROTECTED] > Subject: re: recursive sql statement > > > See http://www.mysql.com/doc/en/TODO_future.html > "Oracle-like CONNECT BY PRIOR ... to search tree-like > (hierarchical) structures." > > Whatever their definition of "The Near Future" is... I'd guess v5 > > J > > ----- Original Message ----- > From: "Bernhard Schmidt" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 09, 2003 2:58 AM > Subject: recursive sql statement > > hi > i searched the mysql doc for support of recursive sql > statements, but found nothing. i am right that mysql does not > support such kind of statements? best regards benny > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
