当前位置 : 主页 > 编程语言 > java >

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log

来源:互联网 收集:自由互联 发布时间:2022-10-15
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)解决 创建函数时出现错误如


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)解决

创建函数时出现错误如下:

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log_数据库

 解决方案:   


set global log_bin_trust_function_creators=TRUE;


This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log_解决方案_02

 函数创建OK

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log_java_03

 

网友评论