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

MYSQL 创建函数，报错：

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

解决办法：

在创建语句前加上：set global log_bin_trust_function_creators=TRUE;