Re: convert parent-child structure to db_nestedset
| From: | Didier Galland | Date: | Mon, 08 Nov 2004 15:39:04 +0000 |
| Subject: | Re: convert parent-child structure to db_nestedset | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-15387@lists.php.net to get a copy of this message | ||
Alain Petignat wrote:
Hi Didier Galland wrote: I would like to convert a parent_id-child_id tree structure into a db_nestedSet one. Perhaps a good sql query could do the job ? Has somebody already solve this problem ? This may help: http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html Good luck Alain Thanks (in late)!Do you think this sql scripts could work with a mysql 4.* db (no stored procedure) ?? Have you ever tried it ? Didier