How to Create a function in mysql 1418

Solution for mysql 1418 failure to create functions: 1418 ThisfunctionhasnoneofDETERMINISTIC, NOSQL, routing (you * might * timeout) (0 mstaken) www.2cto.com solution: 1. mysql> set global log_bin_trust_function_creators = 1; 2. when the system is started -- log-bin-trust-function-creators = 1 3. in my. ini (my. in the [mysqld] File, add a line of content to log-bin-trust-function-
If creators has a 1418 error during create function: you only need to execute set global log_bin _
Trust_routine_creators = 1; then there will be no problem with how to create a function (of course, your function must be correct). This is a mysql bug,
I don't know why. It's okay to do this anyway. in addition, you can also directly in the configuration file my. in cnf, add the following line [mysqld] log_bin_trust_routine_creators = 1. This command can be run in the SQL editor environment without restarting the service.