mysql创建function 报错误1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in

mysql创建function 报错误1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in

报错：

 

 

 

 

解决方法：

执行这条sql就可以了：

 

set global log_bin_trust_function_creators=1;

　　

运行结果：

函数创建成功了