In my experience with similar models, it is usually up to the application, rather than mysql, to perform the recursion
- michael dykman On Sun, 2005-02-06 at 14:34, Andy wrote: > Hi all > > Did anybody reply to this thread? If so I am interested in obtaining those > replies. > > With kind regards > > > Andy > > On Sat February 5 2005 09:43, Auyon Bhattacharya wrote: > > I am new to this. I have been trying to implement a hierarchial data > > structure in Mysql 5.0, on Windows NT with PHP. Can anyone tell me if > > I wish to retrieve an information such as the list of fore-fathers > > from a family tree how do I go about it in MySQL. I think MySQL still > > do not have support for Hierarchial Queries. ( like in Oracle we have > > CONNECT BY PRIOR) . > > Can I use functions to get a array of names or something like that. Or > > is there any other owrk around for it. > > > > PLEASE HELP. > > Auyon Bhattacharya. > > Birla Institute of Technology, > > Mesra,India. > > -- > --- > Registered Linux user number 379093 > --- -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
