简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

请问 预排序遍历树算法(非递归无限极分类算法) ，删除一个分支节点和它所有的子节点有关问题

WBOY
Release： 2016-06-13 12:09:51
Original
1220 people have browsed it

请教 预排序遍历树算法(非递归无限极分类算法) ，删除一个分支节点和它所有的子节点问题



删除一个分支节点和它所有的子节点，从网上看到一段代码，发现这个是错的，
请教一下，这个怎么写SQL，谢谢！
------解决思路----------------------

delete from food where lft>=当前节点的lft AND rgt <= 当前节点的rgt
Copy after login
 
------解决思路----------------------
UPDATE nested_category SET lft = lft - @myWidth WHERE lft > @myRight
应该为
UPDATE nested_category SET lft = lft - @myWidth WHERE lft > @myLeft

Related labels：
nbsp where
source：php.cn
Previous article：php模拟访问返回乱码有关问题 Next article：关于 ++跟&一点疑惑
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Preserve font spacing for a line of text split into separate HTML elements I'm trying to recreate a common technique of splitting words into separate HTML elements s...
From 2023-09-10 18:37:01
0
1
301
How to make this automatically multiline How to make this automatically multiline I'm using HTML and CSS Here is my code (I modifie...
From 2023-08-18 00:10:50
0
1
329
Why is mine wrong in the console? if (time<8) { x="zao";}else{ x="good";}Which problem
From 2023-08-03 14:42:30
0
0
99
Is this the code for conn.php? 下面<?php     $name = $_POST['username'];    $pwd  = md5($_POST['password']);    $sql = &...
From 2023-06-08 18:46:23
0
1
143
After downloading COMPOSER and installing TP6, it always fails to install, as shown in the picture. What do you want? After downloading COMPOSER and installing TP6, it always fails to install, as shown in the...
From 2023-04-01 22:49:35
0
0
632
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！