List:General Discussion« Previous MessageNext Message »
From:Kevin Fries Date:March 27 2002 6:42pm
Subject:RE: hierarchical struture into mysql
View as plain text  
Try looking up the Nested Set Hierarchy structure, which is mainly discussed
by Joe Celko.
There are a number of discussions on usenet (groups.google.com) about it, by
him.  Also, here's a URL which gives his description.  It's a good
structure, and with modification, looks like it can fit about any hierarchy
you've got.

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html?Fr
omTaxonomy=%2Fpr%2F282457

Kevin Fries

> -----Original Message-----
> From: David yahoo [mailto:david_devidal@stripped]
> Sent: Monday, March 25, 2002 3:39 PM
> To: mysql@stripped
> Subject: hierarchical struture into mysql
>
>
> Hi all,
>
> I m looking for a tree struture for which can be easilly
> queried with mysql
> features.
> I only know the tree with row having a parent id.
> Retieving children can only be done with recursive : mysql
> doesnt do that ?
>
> Thanks
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>

Thread
Dropping tablesSteve Buehler25 Mar
  • Impact of Free ORACLEMadProfessor25 Mar
    • Re: Impact of Free ORACLEDan Nelson25 Mar
    • RE: Impact of Free ORACLERichard Forgo25 Mar
      • RE: Impact of Free ORACLEMadProfessor26 Mar
        • RE: Impact of Free ORACLETim Buchalka26 Mar
        • Re: Impact of Free ORACLEMichael Bacarella26 Mar
        • RE: Impact of Free ORACLEFrancesca Shiekh26 Mar
          • RE: Impact of Free ORACLECharles McGrotty26 Mar
    • Re: Impact of Free ORACLEFrancesca Shiekh25 Mar
    • Re: Impact of Free ORACLEGabriel Ricard26 Mar
    • Re: Impact of Free ORACLEJerry Winegarden26 Mar
  • hierarchical struture into mysqlDavid yahoo26 Mar
    • RE: hierarchical struture into mysqlKevin Fries27 Mar
  • Re: Dropping tablesPaul DuBois26 Mar
    • Re: Dropping tablesSteve Buehler26 Mar
      • Re: Dropping tablesPaul DuBois26 Mar
RE: Impact of Free ORACLEAaron Rutledge25 Mar
  • Re: Impact of Free ORACLEjay downs26 Mar
RE: Impact of Free ORACLERBRoa26 Mar
RE: Impact of Free ORACLEJoe Hoffman26 Mar
RE: Impact of Free ORACLEjwubbel26 Mar
  • RE: Impact of Free ORACLEMadProfessor26 Mar
    • RE: Impact of Free ORACLERon Jamison26 Mar
  • RE: Impact of Free ORACLEFrancesca Shiekh26 Mar
RE: Impact of Free ORACLERobert Cross26 Mar
RE: Impact of Free ORACLEJonathan Hilgeman26 Mar