mysql 新建函数样例

CREATE FUNCTION `getSecurityTemplate`(uuid INT) RETURNS text CHARSET utf8
BEGIN
    DECLARE sTemp text;
    DECLARE sTempChd text;
 
    SET sTemp = '';
    SET sTempChd =cast(uuid as CHAR);
    
    SELECT group_concat(id) INTO sTemp FROM security_template where pid = sTempChd;

    IF sTemp THEN
        SET sTemp = concat(sTempChd,',',sTemp);
    ELSE
        SET sTemp = sTempChd;
    END IF;

    RETURN sTemp;
END