mysql 出现的错误

1：创建函数时提示：This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA ，因为当开启log-bin时，函数必须有参数，如果不想有参数，可以

set global log_bin_trust_function_creators=TRUE;  进行设置。  javascript:void(0)

mysql> CREATE FUNCTION simpleFun()RETURNS VARCHAR(20) RETURN "Hello World!"; 
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)
mysql> set global log_bin_trust_function_creators=TRUE; 
Query OK, 0 rows affected

mysql> CREATE FUNCTION simpleFun()RETURNS VARCHAR(20) RETURN "Hello World!"; 
Query OK, 0 rows affected

 

本博客为非营利性个人原创，除部分有明确署名的作品外，所刊登的所有作品的著作权均为本人所拥有，本人保留所有法定权利。违者必究