set global log_bin_trust_function_creators=TRUE;
DELIMITER //
CREATE FUNCTION F_GETPARENT111(StreamJob varchar(100))
RETURNS text CHARSET utf8
BEGIN
DECLARE fid varchar(100);
DECLARE str varchar(1000);
SET fid = ‘#’;
SET str = StreamJob;
WHILE StreamJob is not null do
#SET fid =(SELECT parentid FROM treeNodes WHERE id = rootId);
SET fid =(SELECT etl_job FROM etl_job_stream WHERE Stream_Job = StreamJob);
IF fid is not null THEN
SET str = concat(fid);
SET StreamJob = fid;
ELSE
SET StreamJob = fid;
END IF;
END WHILE;
return str;
END
//
DELIMITER ;
方法提必须放在DELIMITER //内 否则会报
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’ at line 4 错误
set global log_bin_trust_function_creators=TRUE;
DELIMITER //
…
//
DELIMITER ;