Managing Hierarchical Data - The Nested Set Model - insert node
From: <oal_at_tiscali.it>
Date: Thu, 21 Sep 2006 16:35:47 +0200
Message-ID: <eeu802$upp$1_at_newsreader.mailgate.org>
Sorry for my bad english.
I want to add a child(Tom) to Chuck but not on the left of DONNA but on the right of FRED.
Can You help me ?
Date: Thu, 21 Sep 2006 16:35:47 +0200
Message-ID: <eeu802$upp$1_at_newsreader.mailgate.org>
Sorry for my bad english.
I want to add a child(Tom) to Chuck but not on the left of DONNA but on the right of FRED.
Can You help me ?
LOCK TABLE main_menu WRITE;
SELECT _at_myLeft := lft FROM main_menu
WHERE category_id = "Chuck";
UPDATE main_menu SET rgt = rgt + 2 WHERE rgt > _at_myLeft;
UPDATE main_menu SET lft = lft + 2 WHERE lft > _at_myLeft;
INSERT INTO main_menu(name_ita,name_eng, lft, rgt) VALUES('Tom','Tom',
_at_myLeft + 1, @myLeft + 2);
UNLOCK TABLES;
Albert (1, 12)
/ \
/ \
Bert (2, 3) Chuck (4, 11)
/ | \
/ | \
/ | \
/ | \
Donna (5, 6) Eddie (7, 8) Fred (9, 10)
Received on Thu Sep 21 2006 - 16:35:47 CEST