DELIMITER $$
DROP FUNCTION IF EXISTS `getChildList`$$
CREATE DEFINER=`yw_cloud`@`%` FUNCTION `getChildList`(rootId VARCHAR(5000)) RETURNS VARCHAR(3000)
BEGIN
DECLARE sTemp VARCHAR(3000);
DECLARE sTempChd VARCHAR(3000);
SET sTemp = '$';
SET sTempChd = rootId;
WHILE sTempChd IS NOT NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(id) INTO sTempChd FROM cware_std_resource_sort WHERE FIND_IN_SET(parent_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
END$$
DELIMITER ;
修改配置文件:将log_bin_trust_function_creators参数设置为ON
动态修改:
mysql> show variables like 'log_bin_trust_function_creators';
mysql> set global log_bin_trust_function_creators=1;