在MySQL中创建function的时候出现了"ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (youmightwant to use the less safe log_bin_trust_function_creators variable)"的错误信息。如下图所示: 出现这个错误的原因是...
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函数不能创建,是未开启功能。 根据系统提示,导致该错误的原因可...
导入过程中报错信息如下: ERROR 1418 (HY000) at line 18216: 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) 错误原因:如果开启了binlog, 则在...
错误:1023 SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) 消息:关闭’%s’时出错 (errno: %d) 错误:1024 SQLSTATE: HY000 (ER_ERROR_ON_READ) 消息:读取文件’%s’时出错 (errno: %d) 错误:1025 SQLSTATE: HY000 (ER_ERROR_ON_RENAME) 消息:将’%s’重命名为’%s’时出错 (errno: %d) 错误:1026 SQLSTATE...
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) www.2cto.com ...
下面我们测试一下,当开启二进制日志后,如果变量log_bin_trust_function_creators为OFF,那么创建或修改存储函数就会报“ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (youmightwant to use the less safe log_bin...
MySQL开启bin-log后,调用存储过程或者函数以及触发器时,会出现错误号为1418的错误: 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 variabl...
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。
ERROR 1418 (HY000) at line 639: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (youmightwant to use the less safe log_bin_trust_function_creators variable) 原来是因为在主从复制的两台MySQL服务器中开启了二进制日志选项log-...
Re: getting error 1418 (HY0000) 5571 Andrew Gilfrin June 17, 2005 09:27AM Re: getting error 1418 (HY0000) 6463 Per-Erik Martin June 20, 2005 05:16AM Re: getting error 1418 (HY0000) 3916 xiewei67 July 02, 2005 08:07PM Re: getting error 1418 (HY0000) 4057 Per-Erik Martin...