Since I have been writing mysql stored procedures and found that the program is growing in size, I tried to use mysql functions.
Since I have been writing mysql stored procedures and found that the program is growing in size, I tried to use mysql functions.
A problem occurs immediately when a function is created:
ERROR 1418 (HY000): This routine 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_routine_creators
Variable)
Find the solution in the mysql online document:
Http://dev.mysql.com/doc/refman/5.1/zh/stored-procedures.html#create-procedure
You only need to set log_bin_trust_routine_creators to 1. solution:
Add log-bin-trust-function-creators = 1 under [mysqld] Of my. ini
We hope that you will encounter fewer problems during use.
