navicat不能创建函数解决方法分享

CREATE DEFINER=`33323`@`%` FUNCTION `createSaleCode`(`benginStr` varchar,`company_id` int) RETURNS varchar(20) CHARSET utf8 
BEGIN 
 DECLARE nearnum VARCHAR(20); 
 DECLARE nowdatepre VARCHAR(20); 
 DECLARE numout VARCHAR(20); 
 SELECT a.sale_code INTO nearnum FROM d_sale a WHERE a.company_id = company_id ORDER BY a.sale_id DESC limit 1; 
 SELECT concat(extract(year_month from now()),LPAD(extract(day from now()), 2, 0)) INTO nowdatepre; 
 IF locate(nowdatepre,nearnum)>0 
 THEN 
 set numout = nearnum +1; 
 ELSE 
 set numout = concat(beginStr,nowdatepre,'00001'); 
 END IF; 
 RETURN numout; 
END 

delimiter $$ 
CREATE DEFINER=`12212`@`%` FUNCTION createSaleCode(benginStr varchar(20),company_id int(11) ) RETURNS varchar(20) CHARSET utf8 
BEGIN 
 DECLARE nearnum VARCHAR(20); 
 DECLARE nowdatepre VARCHAR(20); 
 DECLARE numout VARCHAR(20); 
 SELECT a.sale_code INTO nearnum FROM d_sale a WHERE a.company_id = company_id ORDER BY a.sale_id DESC limit 1; 
 SELECT concat(extract(year_month from now()),LPAD(extract(day from now()), 2, 0)) INTO nowdatepre; 
 IF locate(nowdatepre,nearnum)>0 
 THEN 
 set numout = nearnum +1; 
 ELSE 
 set numout = concat(beginStr,nowdatepre,'00001'); 
 END IF; 
 RETURN numout; 
END$$ 
delimiter ;