MYSQL自定义函数

DELIMITER $$

USE `p2p_zc`$$

DROP FUNCTION IF EXISTS `getChildLstRight`$$

CREATE DEFINER=`kangjie_zc`@`%` FUNCTION `getChildLstRight`(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(id) INTO sTempChd FROM sys_module WHERE FIND_IN_SET(module_parent_id,sTempChd)>0; 

END WHILE; 

RETURN sTemp; 

END$$

DELIMITER ;