`

MySQL ERROR:This function has none of DETERMINISTIC, NO SQL

阅读更多

向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)

 

原因:

这是我们开启了bin-log, 我们就必须指定我们的函数是否是 
1 DETERMINISTIC 不确定的 
2 NO SQL 没有SQl语句,当然也不会修改数据 
3 READS SQL DATA 只是读取数据,当然也不会修改数据 
4 MODIFIES SQL DATA 要修改数据 
5 CONTAINS SQL 包含了SQL语句 

其中在function里面,只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。 如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。

解决方法:

SQL code
mysql> show variables like '%func%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin_trust_function_creators | OFF | +---------------------------------+-------+ 1 row in set (0.00 sec) mysql> set global log_bin_trust_function_creators=1; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%func%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin_trust_function_creators | ON | +---------------------------------+-------+ 1 row in set (0.00 sec) mysql>
分享到:
评论

相关推荐

    mysql 报错This function has none of DETERMINISTIC解决方案

    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错误的解决办法

    代码如下: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

    mysql> delimiter // mysql> CREATE FUNCTION Uf_new_product_id() -> RETURNS VARCHAR(32) ...ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its

    Mysql导出存储过程.docx

    This function has none of DETERMINISTIC, NOSQL, 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) ...

    开启bin-log日志mysql报错的解决方法

    然而,在开启bin-log时,可能会遇到一些问题,比如在创建存储过程时出现的错误:`ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging...

    创建函数或导入文件时出现的错误.docx

    在MySQL数据库中,当你尝试创建自定义函数或者导入包含自定义函数的SQL文件时,可能会遇到这样一个错误:“his function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary ...

    MySQL 线上运维常见错误、疑难问题录

    在尝试执行某些SQL函数或存储过程时,可能会遇到错误代码1418:“This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declaration and binary logging is enabled”。 **原因分析**: 此...

    Mysql导出存储过程

    ErrorCode: 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 的原因分析及解决方法

    错误信息"ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"提示,存储过程或函数未指定DETERMINISTIC、NO SQL或READS ...

    MySQL数据库开启、关闭、查看函数功能的方法

    然而,在某些情况下,尝试创建或使用自定义函数时,可能会遇到错误提示,例如"ERROR 1418 : This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is ...

    mysql建立自定义函数的问题

    在遇到"ERROR 1418 (HY000): This routine has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"这样的错误时,意味着在尝试创建或修改存储函数(包括存储过程...

    MYSQL 创建函数出错的解决方案

    当你尝试创建用户定义的函数(UDF),并遇到"ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"错误,这意味着由于二...

Global site tag (gtag.js) - Google Analytics