Mysql中创建函数报“ERROR 1418”的解决方法_MySQL
Mysql中创建函数报“ERROR 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)
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)
Sql代码
mysql> show variables like '%func%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF |
+---------------------------------+-------+
1 row in set (0.00 sec)
mysql> set global log_bin_trust_function_creators=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%func%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON |
+---------------------------------+-------+
推荐阅读
-
Mysql5.7中使用group concat函数数据被截断的问题完美解决方法
-
mysql中异常错误ERROR:2002的解决方法
-
ubuntu系统中Mysql ERROR 1045 (28000): Access denied for user root@ localhost问题的解决方法
-
MySQL函数不能创建的解决方法_MySQL
-
MySQL中不能创建自增字段的解决方法
-
mysql创建函数出现1418错误的解决办法_MySQL
-
Mysql中创建函数报“ERROR 1418”的解决方法_MySQL
-
MySQL中不能创建自增字段的解决方法_MySQL
-
Mysql中创建函数报“ERROR 1418”的解决方法_MySQL
-
ubuntu系统中Mysql ERROR 1045 (28000)报错问题的解决方法的图文详解