mysql 出现的错误

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

set global log_bin_trust_function_creators=TRUE;  进行设置。  https://blog.csdn.net/topasstem8/article/details/8216740/

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

巴特西

mysql 出现的错误

最新文章

热门文章