DROP FUNCTION IF EXISTS getChilds;
CREATE FUNCTION getChilds( dpId BigInt ) RETURNS varchar(1000)
BEGIN
DECLARE ptemp varchar(1000)
DECLARE ctemp varchar(1000)
SET ptemp = “”;
SET ctemp = CAST( dpId AS CHAR);
WHILE ctemp is not null DO
set ptrmp = CONCAT( temp,",",ctemp);
SELECT GROUP_CONCAT( deId) INTO ctemp FROM zc_department WHERE find_in_set( dpId,ctemp) > 0
END WHILE
RETURN ptemp
END
版权声明：本文为qq_41985274原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。