mysql：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or RE

 MySQL开启bin-log后，调用存储过程或者函数以及触发器时，会出现错误号为1418的错误:

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)

 

在MySQL中创建函数时出现这种错误的解决方法：
set global log_bin_trust_function_creators=TRUE;