This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled 해결 방법
(Symptom)'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)' on query. Default database: 'dbname'. (Cause)Query: 'CREATE DEFINER=`root`@`%` FUNCTION `getSequence`(seq_name VARCHAR(24)) RETURNS int(4) (Solution)방법1. mysql>SET GLOBAL log_bin_trust_funct..
Server/Linux
2014. 8. 22. 14:00