mysql移植问题

同事在导入mysql文件时发生错误

ERROR 1418 (HY000): This function 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_function_creatorsvariable)

稍微查了一下，用

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
命令就可以解决了

具体原因都是英文的，也没时间看
先记录下网址，以后再研究吧

http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-logging.html

转载于:https://www.cnblogs.com/rapidhorse/archive/2006/10/16/1235153.html