| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> tree like database structure
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
![]() |
![]() |