MySQL This function has none of deterministic, NO SQL ... Cause analysis and resolution of error 1418 (GO)

Workaround:

There are two workarounds, the first one being declared as deterministic or no SQL with reads SQL data when creating subroutines (stored procedures, functions, triggers), for example: Create Definer = Current_User PROCEDURE ' Newproc ' () deterministic BEGIN #Routine body goes here ... END;;

The second is to trust the creator of the subroutine, prohibit the creation, modification of the subroutine when the requirements of Super permission, set the Log_bin_trust_routine_creators Global system variable to 1.

There are three ways to set up:

1. Execute set GLOBAL log_bin_trust_function_creators = 1 on the client;

2.MySQL start, plus--log-bin-trust-function-creators, parameter set to 1

3. add Log-bin-trust-function-creators=1 to the [mysqld] segment in MySQL configuration file My.ini or my.cnf

MySQL This function has none of deterministic, NO SQL ... Cause analysis and resolution of error 1418 (GO)