mysql存储过程和函数同步出错解决办法
错误提示:
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_creators variable)

解决办法:
set global log_bin_trust_function_creators = 1

原因:
log_bin_trust_function_creators参数缺省0,是不允许function的同步的
lunzi   2010-12-24 01:22:20 评论:0   阅读:674   引用:0

发表评论>>

署名发表(评论可管理,不必输入下面的姓名)

姓名:

主题:

内容: 最少15个,最长1000个字符

验证码: (如不清楚,请刷新)

Copyright@2004-2010 powered by YuLog