mysql 1418错误解决 |
您所在的位置:网站首页 › 1418错误 › mysql 1418错误解决 |
记录mysql创建function是遇到的问题:参考:MySQL 创建函数失败提示1418 - 落日长烟 - 博客园 创建mysql函数: drop function if EXISTS getUnitChildList; create function getUnitChildList(rootId BIGINT) RETURNS varchar(2000) begin declare sChildList varchar(2000); declare sChildTemp varchar(1000); set sChildTemp = cast(rootId as char); -- 将rootId强转为字符 while sChildTemp is not null do if(sChildList is not null ) then set sChildList = concat(sChildList,',',sChildTemp); else set sChildList = concat(sChildTemp); end if; select group_concat(menu_id) into sChildTemp from sys_menu_info where find_in_set(parent_id,sChildTemp)>0; end while; return sChildList; end;执行报错: > 1418 - 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)原因:创建函数功能关闭; 查看方式:执行以下语句 show variables like '%func%';结果为: 说明该功能关闭;需要开启此功能: set global log_bin_trust_function_creators=1;再查看是否看启: 结果为以下,则说明成功 再次执行函数sql成功。
|
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |