This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its

来源:互联网 发布:windows u1timed x86 编辑:程序博客网 时间:2024/05/16 12:06

在自定义MySQL函数的时候报了如下错误

[2017-07-01 08:58:30] [HY000][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开启了 bin-log备份,将bin-log取消开启即可

阅读全文
0 0