提示什么错误?
有没有开启创建函数的功能?mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name | Value |
+-----------------------------------------+-------+
| log_bin_trust_function_creators | ON |
+-----------------------------------------+-------+
1 row in set (0.02 sec)二、如果Value处值为OFF,则需将其开启。
mysql> set global log_bin_trust_function_creators=1;
有没有开启创建函数的功能?mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name | Value |
+-----------------------------------------+-------+
| log_bin_trust_function_creators | ON |
+-----------------------------------------+-------+
1 row in set (0.02 sec)二、如果Value处值为OFF,则需将其开启。
mysql> set global log_bin_trust_function_creators=1;
CREATE FUNCTION f_MyFun1(Param1 TEXT)
RETURNS INT
BEGIN
IF (Param1 LIKE 'ABC') THEN
RETURN 1;
END IF; IF (Param1 LIKE 'DEF') THEN
RETURN 2;
ELSE
RETURN 3;
END IF;
END
CREATE FUNCTION f_MyFun1(Param1 TEXT)
RETURNS INT
BEGIN
IF (Param1 LIKE 'ABC') THEN
RETURN 1;
END IF;
IF (Param1 LIKE 'DEF') THEN
RETURN 2;
ELSE
RETURN 3;
END IF;
END$$
DELIMITER ;