mysql报错

--如果报错：You have an error in your SQL syntax，说明SQL语句语法有错，需要修改SQL语句；

如果报错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)
    是因为 存储过程/存储函数在创建时 与之前的 开启慢查询日志冲突了 
    解决冲突：
    临时解决( 开启log_bin_trust_function_creators )
        show variables like '%log_bin_trust_function_creators%';
        set global log_bin_trust_function_creators = 1;
    永久解决：
    /etc/my.cnf 
    [mysqld]
    log_bin_trust_function_creators = 1