SYS_CONNECT_BY_PATH mysql ( tree 구조의 계층 표시 )

[code] CREATE DEFINER=`prcsadmin`@`%` FUNCTION `menu_sys_connect_by_path`( `rootId` VARCHAR (50), `langCode` VARCHAR(3) ) RETURNS varchar(1000) CHARSET utf8 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN DECLARE sParentList VARCHAR (1000); DECLARE sParentTemp VARCHAR(1000); DECLARE sParentNameTemp VARCHAR(1000); SET sParentTemp =CAST(rootId AS CHAR); WHILE sParentTemp IS NOT NULL DO IF (sParentList IS NOT NULL) THEN SET sParentList = CONCAT(sParentNameTemp,' > ...

원문링크 : SYS_CONNECT_BY_PATH mysql ( tree 구조의 계층 표시 )