查询该id下的所有节点,返回自身及所有节点字符
CREATE FUNCTION `queryChildrenInfo` (rootId INT)
RETURNS VARCHAR(1000)
BEGIN
/*
输入参数:ID
输出:ID及其下各级条款ID,例如“13,14,15,16,17,18,19”
*/
DECLARE temp VARCHAR(1000);
DECLARE tempChd VARCHAR(1000);
SET temp = '$';
SET tempChd=CAST(rootId AS CHAR);
WHILE tempChd IS NOT NULL DO
SET temp = CONCAT(temp,',',tempChd);
SELECT GROUP_CONCAT(id 主键id) INTO tempChd FROM bf_column(替换表名) WHERE FIND_IN_SET(pid,tempChd)>0;
END WHILE;
RETURN RIGHT(temp,(LENGTH(temp)-LOCATE(',',temp)));
END