it's
sub(-sub)-categories."
-JF
> -Original Message-
> From: Brent Baisley [mailto:brent@;landover.com]
> Sent: Wednesday, November 06, 2002 11:44 AM
> To: Walter D. Funk
> Cc: [EMAIL PROTECTED]
> Subject: Re: hierarchical Structure in Mysql
>
>
Your structure is going to be a lot like a message board:
Message Board-> Topic->Reply->Reply->...
Where you can reply to someone else's reply or reply to the main topic.
Your setup would have two tables, a "category" table and a "product"
table. You get your cascade by each category having a fie
Hi listErs!
I need to design a database, under a hierarchical structure. This Mysql
database aims to store a catalog
in which I should be able to define:
CATEGORIES -> SubCategories -> Sub-SubCategories -> Product
the only problem, is that I usually use cascaded indexes, but in this case
I sho