论坛 › SQL Server › This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declar

lang110 发表于 2018-10-24 06:04:52

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declar

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
　　不过这个需要重启服务

查看完整版本: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declar