navicat for mysql创建自定义函数

 

 



  


 
 

 


 
 

BEGIN
	#Routine body goes here...
	DECLARE Result varchar(4000);
	DECLARE v_acc_menuid varchar(400);
	DECLARE flag INT;
	DECLARE	a	varchar(200);
  DECLARE menu_cursor CURSOR for 
	select t.menuid from w_manager_rolemenu t where t.roleid =roleid ORDER BY t.menuid;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag=1;
		SET flag=0;
		SET Result='';
    OPEN menu_cursor;
    REPEAT  /*循环*/
		FETCH menu_cursor INTO v_acc_menuid;
				IF (Result='') THEN
					SET Result=v_acc_menuid;
				ELSE
          SET a=CONCAT("#_",v_acc_menuid);
					SET Result=CONCAT(Result,a);
				END IF;
		UNTIL flag
		END REPEAT;
		CLOSE menu_cursor ;
		#SET Result=substr(Result,3,length(Result));
		SELECT SUBSTR(Result,1,(LENGTH(Result)-(LENGTH(substring_index(Result,'#_',-1))+2))) INTO Result;
  RETURN(Result);
END