When you create a function
Error message:
ERROR 1418 (HY000): This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary Loggi NG is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Reason:
This is when we open the Bin-log, we have to specify whether our function is 1 deterministic indeterminate 2 No SQL No SQL statement, and of course not modify data 3 READS SQL data Just read data, of course, will not modify the data 4 Modifi ES SQL data to be modified 5 CONTAINS SQL contains SQL statements
Within the function, only deterministic, NO SQL, and READS SQL DATA are supported. If we open the Bin-log, we must specify a parameter for our function.
Workaround:
-
SQL Code
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 | +---------------------------------+-------+1 Row in set (0.00 sec) MySQL>
MySQL Create method Error: This function has none of deterministic, NO SQL