1.调用自定义函数 mysql>selectsp_function_dbdh_three(); #以前自定义的函数2.报错信息: ERROR1418(HY000): ThisfunctionhasnoneofDETERMINISTIC,NOSQL,orREADSSQ L DATAinits declarationandbinaryloggingisenabled (you*might*wanttouse
确认了解log_bin_trust_function_creators变量的作用: log_bin_trust_function_creators 变量用于控制是否允许在二进制日志中创建不安全的用户定义函数。如果设置为1,则允许创建;如果设置为0(默认值),则不允许。 在MySQL配置文件中定位到[mysqld]部分: MySQL的配置文件通常名为 my.cnf 或my.ini,具体位置可能因...
报错信息:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable) 错误原因 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1、DETERMINISTIC 不确定...
报错信息:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable) 错误原因 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1、DETERMINISTIC 不确定...
mysql创建函数报: you *might* want to use the less safe log_bin_trust_function_creators variable错误: 添加下面这行,问题解决 -- 创建函数数必须执行下面这行,不然无法创建 SETGLOBAL log_bin_trust_function_creators=1; 1. 2. 函数创建成功
SET GLOBAL log_bin_trust_function_creators=1; 关闭 SET GLOBAL log_bin_trust_function_creators=0; https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html?spm=a2c4e.10696291.0.0.6aec19a422wXQ7 标签: 版权所有:奇站网络 转载请注明出处 ...
代码如下:Error Code : 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (0 ms taken) 分析:根据系统提示,导致该错误的原因可能是一个安全...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) 解决办法: 主从上都设置 set global log_bin_trust_function_creators=1。
报错: you *might* want to use the less safe log_bin_trust_function_creators variable image.png 解决方法: 1.mysql>SETGLOBALlog_bin_trust_function_creators=1; 2.系统启动时--log-bin-trust-function-creators=13.在my.ini(linux下为my.conf)文件中[mysqld]标记后加一行内容为 log-bin-trust-functi...
其中在function里面,只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。 解决方法: SQL code mysql> show variableslike'log_bin_trust_function_creators'; +---+---+ | Variable_name | Value | +---+---+ | log_...