Mysql自定义函数functions时报错

delimiter &&

[函数创建语句.....]

[Err] 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)

解决:set global log_bin_trust_function_creators=TRUE;  

原文地址:https://www.cnblogs.com/cyq632694540/p/8268464.html