Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarat

最新推荐文章于 2024-06-28 14:05:05 发布
转载 最新推荐文章于 2024-06-28 14:05:05 发布 · 2.7k 阅读 · 8

本文提供了解决MySQL函数创建时出现的错误提示方法，并介绍了如何启用信任函数创建变量来避免此类问题。

创建函数时出现：

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)


办法

show variables like 'log_bin_trust_function_creators';
set global log_bin_trust_function_creators=1;
show variables like 'log_bin_trust_function_creators';

mysql - 报错1418-This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
高级前端工程师
04-09 3385
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 3182
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 870
创建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...
自定义函数报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in......
u013068184的博客
10-08 5284
创建自定义函数时，发生错误。 -- ---------------------------- -- Function structure for getChildLst -- ---------------------------- DROP FUNCTION IF EXISTS `getChildLst`; DELIMITER ;; CREATE DEFINER=`root`@`%` FUNCT...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its decla
长江某菜鸟的博客
08-30 2925
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, NO SQL, or READS SQL DATA in its declaration
DN金猿的博客
06-28 1252
3. READS SQL DATA 只是读取数据，当然也不会修改数据。2. 在配置文件vi /etc/my.cnf或者my.ini，修改后重启mysql。2. NO SQL 没有SQl语句，当然也不会修改数据。4. MODIFIES SQL DATA 要修改数据。5. CONTAINS SQL 包含了SQL语句。1. 在mysql数据库中执行以下语句 （临时生效，重启后失效）我们创建函数时必须指定我们的函数是否是。
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...”。...
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
10-07 381
mysql错误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)解决。
解决1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and b
桂学成 - just do it
01-15 1762
在mysql5.0版本中创建存储过程时，出现： 1418 - This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declaration and binary logging isenabled (you *might* want to use the less safelog_bin_trus
mysql error 1418:This function has none of DETERMINISTIC, NO SQL,or READS SQL DATA in its declaratio
weixin_44359392的博客
12-10 465
在创建函数begin之前加DETERMINISTIC 或者 NOT DETERMINISTIC CREATE DEFINER = CURRENT_USER PROCEDURE NewProc() DETERMINISTIC BEGIN #Routine body goes here… END; DETERMINISTIC和NOT DETERMINISTIC指出一个子程序是否对给定的输入总是产生同样的结果。 如果没有给定任一特征，默认是NOT DETERMINISTIC，所以必须明确指定DETERMIN
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 1143
错误信息: [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_...
mysql 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
老朱的博客
06-05 1764
错误场景：使用mysql创建、调用存储过程，函数以及触发器的时候会有错误符号为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) 这个函数定义中没有包含det
1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and bin
m0_56419249的博客
08-01 3085
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)
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
m0_38102561的博客
09-05 2725
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】运行函数时报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
DJames23的博客
04-11 2825
在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函数时
错误码: 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and
qiuyepiaoling的专栏
04-24 2444
创建存储函数的时候，会遇到这样的错误： SQL： DELIMITER ;; CREATE FUNCTION `GetGuid`() RETURNS VARCHAR(40) CHARSET utf8 COMMENT '获取不带"-"的GUID' BEGIN DECLARE id VARCHAR(40); SET id=(SELECT REPLACE(UUID(),'-','')); R
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` 中的一个或...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值