1418 -This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
今天在mysql中创建函数的时候,报错如下:
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。
解决办法:
set global log_bin_trust_function_creators=TRUE;
posted on 2023-10-30 10:11 zyp_java_net 阅读(94) 评论(0) 编辑 收藏 举报