MySQL implements the SYS_CONNECT_BY_PATH function similar to Oracle.

The SYS_CONNECT_BY_PATH function in Oracle facilitates development. How does MySQL implement similar functions?

The SYS_CONNECT_BY_PATH function in Oracle facilitates development. How does MySQL implement similar functions?

The SYS_CONNECT_BY_PATH function in Oracle facilitates development. How does MySQL implement similar functions?

DELIMITER $
Create function 'getparentlist' (rootId VARCHAR (50) returns varchar (1000)
BEGIN
DECLARE sParentList VARCHAR (1000 );
DECLARE sParentTemp VARCHAR (1000 );
SET sParentTemp = CAST (rootId as char );
WHILE sParentTemp IS NOT NULL DO
IF (sParentList is not null) THEN
SET sParentList = CONCAT (sParentTemp, '/', sParentList );
ELSE
SET sParentList = CONCAT (sParentTemp );
End if;
SELECT GROUP_CONCAT (parent_module_id) INTO sParentTemp FROM TOP_SYS_MODULE WHERE FIND_IN_SET (module_id, sParentTemp)> 0;
End while;
RETURN sParentList;
END $
DELIMITER;

SELECT module_id, parent_module_id, getParentList (module_id) FROM TOP_SYS_MODULE;