Error message:[ERR] 1418-this function has none of deterministic, NO SQL, or READS SQL DATA in its declaration and binary logging IS-enabled (you *might* want-use the less safe log_bin_trust_function_creators variable)Cause: This is when we open the Bin-log, we have to specify whether our function is 1 deterministic indeterminate 2 No SQL without SQL statement 3 READS SQL data Just read data 4 modifies SQL data to modify number According to 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.
The workaround for this error occurs when creating a function in MySQL:set global log_bin_trust_function_creators=true;Orset global Log_bin_trust_function_creators=1;
ThisfunctionHasNoneOfDeterministic,noSql,orR "Title=" [err]1418ThisfunctionHasNoneOfDeterministic,noSql,orR ">
[err]1418 This function has none of deterministic
