该错误信息的完整形式是:“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)”。这表示MySQL在启用二进制日志(binlog)的情况下,...
mysql创建function报错误1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in 问题描述: 执行创建函数的sql语句时,提示:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled 原因分析: 我们创建函数时必须指定我们...
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...
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) 1. 2. 3. 解决方法如下: 1. mysql> set global log_bin_trust_function_cre...
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) 原因分析 导致该错误的原因可能是一个安全设置方面的配置,查手册log_bin_tru...
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) 这个函数定义中没有包含deterministic,no sql或者read sql data中的一种,并且...
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) mysql> create function fun1 (num int(9)) returns int(9) reads sql data ...
MySQL This function has none of DETERMINISTIC, NO SQL...错误1418 的原因分析及解决方法 解决方法: 解决办法也有两种, 第一种是在创建子程序(存储过程、函数、触发器)时,声明为DETERMINISTIC或NO SQL与READS SQL DATA中的一个, 例如: CREATE DEFINER = CURRENT_USER PROCEDURENewProc() DETERMINISTIC BEGIN #...
简介 当执行MySQL函数语句时,创建sql函数失败, 并显示错误信息为错误代码1418;具体报错信息如下:1 queries executed, 0 success, 1 errors, 0 warnings...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...
[Err] 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) 原因: 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 ...