mysql报错This function has none of DETERMINISTIC. NO SOL or READS SOL DATA...
是因为 存储过程/存储函数在创建时 与 开启慢查询日志冲突了
解决冲突:
临时解决:开启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

浙公网安备 33010602011771号