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
posted @ 2022-12-05 09:06  镇魂帆-张  阅读(103)  评论(0编辑  收藏  举报