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)
原因：
復(fù)制代碼 代碼如下:
這是我們開(kāi)啟了bin-log, 我們就必須指定我們的函數(shù)是否是 1 DETERMINISTIC 不確定的 2 NO SQL 沒(méi)有SQl語(yǔ)句，當(dāng)然也不會(huì)修改數(shù)據(jù) 3 READS SQL DATA 只是讀取數(shù)據(jù)，當(dāng)然也不會(huì)修改數(shù)據(jù) 4 MODIFIES SQL DATA 要修改數(shù)據(jù) 5 CONTAINS SQL 包含了SQL語(yǔ)句
其中在function里面，只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我們開(kāi)啟了 bin-log, 我們就必須為我們的function指定一個(gè)參數(shù)。
解決方法：
復(fù)制代碼 代碼如下:
SQL code mysql> show variables like 'log_bin_trust_function_creators'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin_trust_function_creators | OFF | +---------------------------------+-------+ mysql> set global log_bin_trust_function_creators=1; mysql> show variables like 'log_bin_trust_function_creators'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin_trust_function_creators | ON |
解決Mysql服務(wù)器啟動(dòng)時(shí)報(bào)錯(cuò)問(wèn)題的方法MySQL 啟動(dòng)報(bào)錯(cuò):File ./mysql-bin.index not found (Errcode: 13)mysql服務(wù)無(wú)法啟動(dòng)報(bào)錯(cuò)誤1067解決方法(mysql啟動(dòng)錯(cuò)誤1067 )linux mysql 報(bào)錯(cuò)：MYSQL:The server quit without updating PID filephpmyadmin報(bào)錯(cuò)：#2003 無(wú)法登錄 MySQL服務(wù)器的解決方法MySql報(bào)錯(cuò)Table mysql.plugin doesn’t exist的解決方法MyEclipse連接MySQL數(shù)據(jù)庫(kù)報(bào)錯(cuò)解決辦法mysql報(bào)錯(cuò)：MySQL server version for the right syntax to use near type=InnoDB的解決方法MySQL Administrator 登錄報(bào)錯(cuò)的解決方法mysql啟動(dòng)報(bào)錯(cuò)MySQL server PID file could not be found
