DELIMITER $$
USE `ylq_copy`$$
DROP FUNCTION IF EXISTS `getChildList`$$
CREATE DEFINER=`ylqtest`@`%` FUNCTION `getChildList`(rootId INT) RETURNS VARCHAR(1000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '$';
SET sTempChd =CAST(rootId AS CHAR);
WHILE sTempChd IS NOT NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(match_group_id) INTO sTempChd FROM match_group_info WHERE FIND_IN_SET(match_group_parent_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
USE `ylq_copy`$$
DROP FUNCTION IF EXISTS `getChildList`$$
CREATE DEFINER=`ylqtest`@`%` FUNCTION `getChildList`(rootId INT) RETURNS VARCHAR(1000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '$';
SET sTempChd =CAST(rootId AS CHAR);
WHILE sTempChd IS NOT NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(match_group_id) INTO sTempChd FROM match_group_info WHERE FIND_IN_SET(match_group_parent_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
END$$
USE `ylq_copy`$$
DROP FUNCTION IF EXISTS `getParentLst`$$
CREATE DEFINER=`ylqtest`@`%` FUNCTION `getParentLst`(rootId INT) RETURNS VARCHAR(1000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '$';
SET sTempChd =CAST(rootId AS CHAR);
WHILE sTempChd IS NOT NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(match_group_parent_id) INTO sTempChd FROM match_group_info WHERE FIND_IN_SET(match_group_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
END$$
DELIMITER ;