Operation on hierchical datas

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

Operation on hierchical datas

Post by PHPycho »

Hello forums!!
I would like to know the queries required to operate on hierarchical datas like INSERT, SELECT, UPDATE, DELETE etc. so that the action can be done with one query.
My hierarchical data are contained in the table as:
|id|title|parent_id|description|
Thanks in advance for the suggestion.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

The maximum you can retrieve at any given time is directly related to how many joins you perform to the same table in the query.

Hierarchical data is often stored with a different structure to ease the queries. Since they have been talked about so much, I'll let you search for them before saying anything further.
Post Reply