List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:October 19 2004 3:29pm
Subject:Re: Ask for help on a mysql problem
View as plain text  
In article <02d901c4b5d0$a1691520$0a02a8c0@martijn>,
"Martijn Tonies" <m.tonies@stripped> writes:

> That is ONE way to store a tree structure :-)

> Another would be:

> ITEMS
> (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> other stuff)

> ITEM_PARENT
> (ItemID int,
>  ParentID int
> primary key (ItemID, ParentID)
> )


> I prefer the latter.

The latter is not a tree, but a directed graph.

Thread
Ask for help on a mysql problemTeng Wang15 Oct
  • Re: Ask for help on a mysql problemDiona Kidd15 Oct
  • Re: Ask for help on a mysql problemEgor Egorov19 Oct
  • Re: Ask for help on a mysql problemMartijn Tonies19 Oct
  • Re: Ask for help on a mysql problemHarald Fuchs19 Oct
  • Re: Ask for help on a mysql problemMartijn Tonies19 Oct
Re: Ask for help on a mysql problemMartijn Tonies19 Oct