在MySQL中创建函数时,如果遇到错误信息“this function has none of deterministic, no sql, or reads sql data in its declaration and binary logging is enabled”,这通常意味着在启用了二进制日志(binary logging)的情况下,你尝试创建的函数没有声明为确定性(deterministic)、不包含SQL语句(no sql)、也不读取SQ...
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) 中文大意就是使用百度翻译翻译翻译 此函数的声明中没有DENTISTIC、NO SQL或READS SQL DATA,并且启用了...
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) 我本机的错误: {"This function has none of DETERMINISTIC, NO SQL, or RE...
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) 问题原因: 原因是开启了log-bin日志,创建函数时,函数中没有包含DETERMINISTIC,NOSQL和 READ...
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) 原因: 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1 DETERMIN...
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) 问题原因 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1 DETERMINI...
其中在function里面,只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。 解决方法: SQL codemysql> show variables like "log_bin_trust_function_creators";+---+---+| Variable_name| Value |+---+---+| log_bin_trust_function...
简介: MySQL:ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA 环境mysql> select version(); +---+ | version() | +---+ | 8.0.16 | +---+ 定义函数-- 最简单的函数 create function foo() returns int return 10;报错ERROR 1418 (HY000): This func...
本⽂章向朋友们介绍开启bin-log⽇志mysql报错:This function has none of DETERMINISTIC, NO SQL解决办法,创建存储过程时 出错信息：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 ...
在MySQL中创建函数时,报错如下: 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) 错误原因 ...