Re: Hierarchical list...

2004-03-07 Thread olinux
check this thread - lots of links for more info. http://lists.mysql.com/mysql/157588 olinux --- Richard Carlier wrote: > Hi ! > > There is any way to have hierarchical list with > Mysql, like the Oracle > START WITH and CONNECT BY ? > _

Hierarchical list...

2004-03-07 Thread Richard Carlier
Hi ! There is any way to have hierarchical list with Mysql, like the Oracle START WITH and CONNECT BY ? Something like : CREATE TABLE links_categories ( id int(11) NOT NULL auto_increment, parent int(11) default NULL, libelle varchar(50) default NULL, PRIMARY