This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary

標籤：function

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary

mysql的設定預設是不允許建立函數

解決辦法1:

執行：

SET GLOBAL log_bin_trust_function_creators = 1;

不過 重啟了 就失效了

注意： 有主從複製的時候 從機必須要設定  不然會導致主從同步失敗

解決辦法2：

在my.cnf裡面設定

log-bin-trust-function-creators=1

不過這個需要重啟服務

本文出自 “給我三顆痣” 部落格，請務必保留此出處http://wushuangjay.blog.51cto.com/3125450/1561873

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary