This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
来源:互联网 发布:mac程序卸载 编辑:程序博客网 时间:2024/06/05 15:57
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary
mysql的设置默认是不允许创建函数
解决办法1:
执行:
SET GLOBAL log_bin_trust_function_creators = 1;
不过 重启了 就失效了
注意: 有主从复制的时候 从机必须要设置 不然会导致主从同步失败
解决办法2:
在my.cnf里面设置
log-bin-trust-function-creators=1
不过这个需要重启服务
- Mysql创建Function出现This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA...
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its
- 错误码: 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- ERROR 1418 (HY000) at line 1323: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- 解决1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and b
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration a
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its decla
- This function has none of DETERMINISTIC, NO SQL, or
- 【编程珠玑】生成k个1-n的随机数
- date(): It is not safe to rely on the system’s timezone settings
- 优秀的程序员写出好代码的5个建议——网摘
- 重装mysql 出错,解决方法
- CvDrawContours绘制轮廓
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- 黑马程序员_使用C#轻松编写.Net组件
- Zen Cart 免费模块10个详解– 能够助你的外贸获得更多订单
- 强大的Firefox!引导我的网上生活
- JAVA中int、String的类型转换
- django开发学习步骤
- stl的学习
- 小心逗号表达式
- ps制作玻璃效果(整体透明且上为白色半透明下为无色透明)的PNG格式背景图片