创建函数失败

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de....

在MySQL中创建函数时出现这种错误的解决方法：
set global log_bin_trust_function_creators=TRUE;


DELIMITER //
CREATE DEFINER=`dbesblog`@`%` FUNCTION `DAY_TRANS_STSTIC_IDSEQ_NEXTVAL`() RETURNS BIGINT(20)
BEGIN
INSERT INTO esbseq.DAY_TRANS_STSTIC_IDSEQ VALUES (NULL);
SET @DAY_TRANS_STSTIC_ID_val=LAST_INSERT_ID() ;
RETURN @DAY_TRANS_STSTIC_ID_val;
END//
DELIMITER ;
再创建成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29096438/viewspace-1735386/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29096438/viewspace-1735386/