MySQL中创建函数时出现ERROR 1418

最新推荐文章于 2024-09-16 08:00:00 发布

qq_2230520319

最新推荐文章于 2024-09-16 08:00:00 发布

阅读量178

点赞数 1

文章标签： mysql

本文链接：https://blog.csdn.net/qq_41009122/article/details/105577165

版权

mysql> delimiter //
mysql> CREATE FUNCTION Uf_new_product_id()
    -> RETURNS VARCHAR(32)
    -> BEGIN
    -> declare new_id varchar(32);
    -> set new_id = 'ID';
    -> Return new_id;
    -> END
    -> //
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中创建函数时出现这种错误只要设置全局日志信任函数创建者为真即可

mysql> set global log_bin_trust_function_creators=TRUE//  
Query OK, 0 rows affected (0.00 sec)

设置完成后即可创建函数成功

mysql> CREATE FUNCTION Uf_new_product_id() RETURNS VARCHAR(32) BEGIN declare new_id varchar(32); set new_id = 'ID'; return new_id; END//
Query OK, 0 rows affected (0.00 sec)