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 ;
再建立成功

建立函式失敗

相關文章