Posted by asdf on 02/02/07 06:00

"Geoff Muldoon" <geoff.muldoon@trap.gmail.com> wrote in message
news:MPG.202d73c2bb4170f39898d4@news.readfreenews.net...
> laurente1234@yahoo.com says...
>> I think it is not a good table design. You need to learn database
>> normalization first.
>> http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
>
> Internally self-referencing tables are actually *good* database design,
> and satisfy normalization rules.
>
> <aside>
>
> Because it's difficult to follow context.
>
> Why is top-posting bad?
>
> </aside>
>
[snip - see OP]

I agree... nothing wrong with self-reference if you are trying to construct
a tree.

• Next in forum: Re: using conditional statements in where-clause
• Prev in forum: Re: High performance
• Thread view: Re: I have sub-categories but want to display full category path

[Reply to this message]