mysql 导入sql文件，出现ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL报错

最新推荐文章于 2022-08-29 10:59:08 发布
最新推荐文章于 2022-08-29 10:59:08 发布
阅读量6.9k 收藏 12
点赞数 5
分类专栏： mysql 文章标签： mysql function
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/bianb123/article/details/83088612
版权

ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL

mysql的设置默认是不允许创建函数

1、更改全局配置

      SET GLOBAL log_bin_trust_function_creators = 1;  

      有主从复制的时候 , 从机必须要设置  不然会导致主从同步失败

2、更改配置文件my.cnf  

      log-bin-trust-function-creators=1   重启服务生效

三月白丁
关注
专栏目录
mysql - 报错1418-This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
高级前端工程师
04-09 2716
mysql，报错，linux，Navicat for MySQL，可视化工具mysql，mysql无法保存函数，MySQL保存函数就报错，只要保存函数就会出错，如何解决mysql函数保存提示错误，MySQL 创建函数报错，弹框报错，mysql错误代码1418，mysql报错解决教程，This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable
mysql - 报错1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarati
最新发布
高级前端工程师
01-19 2539
mysql，navicat，navicat弹框报错1418错误代码，mysql使用navicat中运行函数时报错，mysql创建函数存储过程报错，mysql函数保存时报错1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarati，如何解决mysql报错，怎么解决navicat无法进行函数保存报错，navicat进行mysql函数的保存时弹框提示，自定义函数报错[Err] 1418，mys
MySQL This function has none of DETERMINISTIC, NO SQL...错误1418 的原因分析及解决方法
热门推荐
Sky 的专栏
11-06 9万+
MySQL开启bin-log后，调用存储过程或者函数以及触发器时，会出现错误号为1418的错误: 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* wan
[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
IT382566697的专栏
06-24 980
错误信息: [Err] 1418 - 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_...
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
lxpbs8851的专栏
05-04 7901
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; 不过 重启了 就失效了
自定义函数报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in......
u013068184的博客
10-08 5061
创建自定义函数时，发生错误。 -- ---------------------------- -- Function structure for getChildLst -- ---------------------------- DROP FUNCTION IF EXISTS `getChildLst`; DELIMITER ;; CREATE DEFINER=`root`@`%` FUNCT...
mysql 报错This function has none of DETERMINISTIC解决方案
12-16
MySQL数据库在开启二进制日志(bin-log)功能后，可能会遇到一个特定的错误：“This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled...”。...
mysql创建函数出现1418错误的解决办法
12-15
代码如下:Error Code : 1418 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_...
mysql error 1418:This function has none of DETERMINISTIC, NO SQL,or READS SQL DATA in its declaratio
weixin_44359392的博客
12-10 404
在创建函数begin之前加DETERMINISTIC 或者 NOT DETERMINISTIC CREATE DEFINER = CURRENT_USER PROCEDURE NewProc() DETERMINISTIC BEGIN #Routine body goes here… END; DETERMINISTIC和NOT DETERMINISTIC指出一个子程序是否对给定的输入总是产生同样的结果。 如果没有给定任一特征，默认是NOT DETERMINISTIC，所以必须明确指定DETERMIN
MySQL：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
彭世瑜的博客
04-10 2787
环境 mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.16 | +-----------+ 定义函数 -- 最简单的函数 create function foo() returns int return 10; 报错 ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS
weixin_34185364的博客
11-20 266
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...
【MySQL】运行函数时报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
DJames23的博客
04-11 2683
在navicat中运行函数时报错，报错信息如下： [Err] 1418 - 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) 参考博客： 怎么解决执行MySQL函数时
Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarat
qq_48550824的博客
12-16 296
Error Code: 1418. 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) mysql workbench创建函数时遇到的报错 解决方法见： Error Code
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA 的解决办法
hellenlee22的博客
12-12 158
今天创建函数，遇到以下问题： ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_tru...
sql去掉html标签
不积跬步，无以至千里；不积小流，无以成江海。
09-27 726
开启-信任存储函数创建者 简单介绍一下，当二进制日志启用后，这个变量就会启用。它控制是否可以信任存储函数创建者，不会创建写入二进制日志引起不安全事件的存储函数。如果设置为0（默认值），用户不得创建或修改存储函数，除非它们具有除CREATE ROUTINE或ALTER ROUTINE特权之外的SUPER权限。 设置为0还强制使用DETERMINISTIC特性或READS SQL DATA或NO SQ...
2022-08-29 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declara
ZT1090258642的博客
08-29 446
报错信息： 1418 - 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)ps：修改log_bin_trust_function_creators的值为OFF。...
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
m0_38102561的博客
09-05 2601
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled创建函数时报错错误分析解决方案 创建函数时报错 错误分析 我们创建函数时必须指定我们的函数是否是 DETERMINISTIC 不确定的 NO SQL 没有SQl语句，...
mysql：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or RE
guoweisharp的博客
07-09 171
 MySQL开启bin-log后，调用存储过程或者函数以及触发器时，会出现错误号为1418的错误: 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* ...
ERROR 1418 (HY000)：MySQL This function has none of DETERMINISTIC, NO SQL
ReverieZH的博客
03-05 160
ERROR 1418 (HY000):MySQL This function has none of DETERMINISTIC, NO SQL… 更改全局配置 SET GLOBAL log_bin_trust_function_creators = 1; 然后执行
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
12-16
这个错误通常出现在MySQL中创建函数时，表示函数声明中没有包含DETERMINISTIC、NO SQL或READS SQL DATA中的任何一个，同时二进制日志记录也是启用的。这个错误提示建议你使用log_bin_trust_function_creators变量来...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值