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;

运行结果：

函数创建成功了