Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL se

来源:互联网 发布:电力网络 编辑:程序博客网 时间:2024/05/17 23:10
再创建项目的时候报出Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`company_id` int) RETURNS varchar(20) CHARSET utf8

BEGIN错误,上网查找原因,原来是因为没有打开创建函数的开关,

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

show variables like '%func%';

打开创建函数开关:

SET GLOBAL log_bin_trust_function_creators=1;

关闭创建函数开关:

SET GLOBAL log_bin_trust_function_creators=0;

0 0
原创粉丝点击