qq_33141369的博客

DELIMITER $$ CREATE FUNCTION getParentList (rootId VARCHAR (50)) RETURNS VARCHAR (1000) BEGIN   DECLARE sParentList VARCHAR (1000) ;   DECLARE sParentTemp VARCHAR(1000);   SET sParentTemp =CAST

DELIMITER $$ CREATE FUNCTION getChildList (rootId VARCHAR(50)) RETURNS varchar(1000) BEGIN DECLARE sChildList VARCHAR(1000); DECLARE sChildTemp VARCHAR(1000); SET sChildTemp =cast(rootId as C

CREATE FUNCTION SPLIT_STR(   x VARCHAR(255),   delim VARCHAR(12),   pos INT ) RETURNS VARCHAR(255) RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),        LENGTH(SUBSTRING_INDEX(x, deli