MySQL错误[ERR] 1064 - You have an error in your SQL syntax;

MySQL打开创建函数的开关,

查询创建函数开关是否打开:

show variables like '%func%';

打开创建函数开关:

SET GLOBAL log_bin_trust_function_creators=1;

关闭创建函数开关:

SET GLOBAL log_bin_trust_function_creators=0;

 

posted @ 2018-01-26 11:45  javakam  阅读(2875)  评论(0编辑  收藏  举报