新建函数报错
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'XXX' at line 1
执行下面语句 开启函数功能
mysql> SET GLOBAL log_bin_trust_function_creators=1;
再进行函数新建
DELIMITER ;;
CREATE FUNCTION NVL(name varchar(50)) RETURNS varchar(50)
BEGIN
RETURN IFNULL(name,"");
END
;;
DELIMITER ;