【MySQL】ERROR 1418 (HY000) This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

最新推荐文章于 2025-06-12 10:30:47 发布
最新推荐文章于 2025-06-12 10:30:47 发布
阅读量487 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： 数据库 文章标签： mysql
原文链接：https://blog.csdn.net/qq_43060870/article/details/107826815
本文解决了一个常见的MySQL函数创建时遇到的错误：'This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declaration and binary logging is enabled'. 提供了通过设置全局变量log_bin_trust_function_creators为TRUE来解决该问题的方法。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

MySQL 在创建函数时报如下错误：

[HY000][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)

解决方法：

set global log_bin_trust_function_creators=TRUE;
mysql - 报错1418-This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
高级前端工程师
04-09 3245
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 3063
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
创建function时出错
青岛金鑫-java技术攻略 嫁给我是你一生的赌注，我怎么忍心让你输？
04-06 852
创建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, NO SQL, or READS SQL DATA in its declar
最新发布
weixin_52568278的博客
06-12 143
【代码】ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declar。
[HY000][1418] This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
qq_43060870的博客
08-05 688
Mysql在创建函数时报如下错误： [HY000][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) 解决方法： set global log
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS
weixin_34185364的博客
11-20 301
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...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its decla
长江某菜鸟的博客
08-30 2892
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
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 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
彭世瑜的博客
04-10 2834
环境 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
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
m0_38102561的博客
09-05 2702
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled创建函数时报错错误分析解决方案 创建函数时报错 错误分析 我们创建函数时必须指定我们的函数是否是 DETERMINISTIC 不确定的 NO SQL 没有SQl语句，...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA...
Mr_Melody的专栏
02-05 4052
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
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declara
qq_46402333的博客
03-14 660
用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 SQLmysql的设置默认是不允许创建函数
IT_LL的专栏
11-14 456
mysql创建函数存储过程报错。
1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and bin
m0_56419249的博客
08-01 3031
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)
解决SQL函数保存报错:1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its..
后端开发
06-01 2726
由于mysql数据库开启了binlog日志，又因为在binlog开启的状态下，系统默认在binlog开启的时候是`关闭生成函数`的使用的。这是因为系统需要信任生成函数，如果某天需要通过binlog日志回滚，而所有事务里就带有某些损害系统的函数
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` 中的一个或...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值