Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> tree like database structure

tree like database structure

From: Abhi <aak_at_starline.ee>
Date: Wed, 8 Mar 2006 23:25:16 +0200
Message-ID: <440f4b90$1_2@news.estpak.ee>


Hi!

Can someone please direct me to a tutorial or give some hints? I am trying to develop a tree like database with MySQL.

I have main categories in one table. Now, each category has many subcategories and subcategories have their subcategories etc etc. All together seven levels.

How is such thing done most elegantly? I have some ideas with seven tables and too many category ID's. I am sure there are a lot of better ways to do this.

Sorry, for bad english, I hope I managed to explain the point.

Abhi Received on Wed Mar 08 2006 - 15:25:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US