|
+---------------------------------+-------+
mysql> set global log_bin_trust_function_creators=1;
mysql> show variables like ‘log_bin_trust_function_creators‘;
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators |
ON |
+---------------------------------+-------+
这样添加了参数以后，如果mysqld重启，那个参数又会消失，因此记得在my.cnf配置文件中添加：
log_bin_trust_function_creators=1
DELIMITER //
CREATE FUNCTION getNthHighestSalary(N INT)
RETURNS INT
BEGIN
RETURN(SELECT 555);
END//
DELIMITER ;
mysql创建function，存储过程报错，This function has none of DETERMINISTIC, NO SQL解决办法
标签：The get blog oba 包含 原因 creat 信息 报错
