This function has none of DETERMINISTIC, NO SQL错误解决办法
来源:互联网 发布:java 图片验证码 开源 编辑:程序博客网 时间:2024/06/06 04:04
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
这是我们开启了bin-log, 我们就必须指定我们的函数是否是
1 DETERMINISTIC 不确定的
2 NO SQL 没有SQl语句,当然也不会修改数据
3 READS SQL DATA 只是读取数据,当然也不会修改数据
4 MODIFIES SQL DATA 要修改数据
5 CONTAINS SQL 包含了SQL语句
其中在function里面,只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。
解决方法如下:1. mysql> set global log_bin_trust_function_creators = 1;2. 系统启动时 --log-bin-trust-function-creators=13. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators=1
阅读全文
0 0
- This function has none of DETERMINISTIC, NO SQL错误解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法 【转】
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL 错误处理
- 切换工作空间后,eclipse导入svn项目
- WEB端线上偶现问题如何复现?
- 探讨医疗人工智能之眼科AI的真实应用场景(肽积木CEO柏文洁)
- 冒泡排序
- C# 之泛型详解
- This function has none of DETERMINISTIC, NO SQL错误解决办法
- Python错误 'gbk' codec can't decode byte 0x80 in position 0: illegal multibyte sequence
- keytool 用法总结
- 博客已经转移
- zookeeper命令行操作
- [learning materials] tone and phonetics
- lua脚本学习13 迭代器
- Spring AOP (一)
- 适配器设置图片