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

最新推荐文章于 2024-05-16 11:26:46 发布
最新推荐文章于 2024-05-16 11:26:46 发布
阅读量405 收藏
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/hyj_123/article/details/108199798
版权

遇到一个错误：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_bin_trust_function_creators variable)
解决方式： set global log_bin_trust_function_creators=TRUE;

hyj_123
关注
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its decla
长江某菜鸟的博客
08-30 2876
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_bin_trust_function_cr
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its decla
weixin_46055410的博客
09-27 520
创建MySQL函数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_bin_trust_function_creators variable)
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA...
Mr_Melody的专栏
02-05 4038
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_bin_trust_function_creators variable) 查了一些资料，解决办法是把log_bin_trust_function_cr
MySQL：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
彭世瑜的博客
04-10 2820
环境 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
创建function时出错
青岛金鑫-java技术攻略 嫁给我是你一生的赌注，我怎么忍心让你输？
04-06 843
创建function时 出错信息： 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 sa...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declara
qq_46402333的博客
03-14 651
用navicat向mysql导入my.sql建表一直数据导入不完全 原因： 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1 DETERMINISTIC 不确定的 2 NO SQL 没有SQl语句，当然也不会修改数据 3 READS SQL DATA 只是读取数据，当然也不会修改数据 4 MODIFIES SQL DATA 要修改数据 5 CONTAINS SQL 包含了SQL语...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
kongkong的专栏
06-26 279
创建function的时候，报这个错误。
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS
weixin_33755554的博客
04-22 72
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_bin_trust_...
mysql：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or RE
guoweisharp的博客
07-09 200
 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* ...
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
m0_38102561的博客
09-05 2686
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...
qq_43941925的博客
02-17 1282
在创建存储函数的时候出现了报错： 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_bin_trust_function_creators variable) mysql的设置默认是不允许创建函数 更改全局
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQLmysql的设置默认是不允许创建函数
IT_LL的专栏
11-14 438
mysql创建函数存储过程报错。
Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarat
qq_48550824的博客
12-16 339
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
MySQL This function has none of DETERMINISTIC, NO SQL...错误1418
流水不争先而争滔滔不绝.
02-09 397
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 want t...
MySQL创建function报ERROR 1418 (HY000)
fenijd的博客
05-16 1358
方案二这条语句是临时生效的，重启数据库后将不再生效。需要在每次创建函数或触发器的时候执行一次本语句。也有文章推荐直接在sql的配置文件设置global log_bin_trust_function_creators = 1，博主个人认为是不推荐的。因为这样会导致任何用户均可创建没有 DETERMINISTIC、NO SQL 或 READS SQL DATA 的函数，从而影响数据库的安全。
ERROR 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
最新发布
11-12
这个错误信息（ERROR 1418）在MySQL数据库中出现，通常意味着当二进制日志（Binary Logging）功能启用时，尝试创建或修改一个函数，但该函数的声明中缺少`DETERMINISTIC`, `NO SQL`, 或 `READS SQL DATA` 中的一个或...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值