[EMAIL PROTECTED]
> Subject: hierarchical struture into mysql
>
>
> Hi all,
>
> I m looking for a tree struture for which can be easilly
> queried with mysql
> features.
> I only know the tree with row having a parent id.
> Retieving children can only be
Hi,
from my experience
CREATE TABLE message (
id int(10) NOT NULL auto_increment,
parent_id int(10) NOT NULL default '0',
parents varchar(255) NOT NULL default '',
level tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY parent_id (parent_id),
KEY parents (parents)
)
Hi all,
I m looking for a tree struture for which can be easilly queried with mysql
features.
I only know the tree with row having a parent id.
Retieving children can only be done with recursive : mysql doesnt do that ?
Thanks
_
Do You
