mysql怎么保存一个函数_mysql中我写了一个存储函数 为什么会报错 请指点

delimiter&&createfunctionalarm_info()returnsvarchar(100)readssqldatabegindeclarecountsint(11);declarenint(11);declarefix_timeint(11);declarediffint(11);declareresultvarch...

delimiter &&

create function alarm_info()

returns varchar(100) reads sql data

begin

declare counts int(11);

declare n int(11);

declare fix_time int(11);

declare diff int(11);

declare result varchar(100);

set n=1;

select count(*) into counts from total;

while counts>=n

select tablenames,time_colum,fix_time into names,times,fixs from total where id=n;

select round(time_to_sec(timediff(sysdate(),(select times from names order by id desc limit 1)/60) into diff;

if(diff>fix_time) then result=tablenames;

end if;

n=n+1;

end &&;

delimiter;

ERROR 1064 (42000): 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 'select tablenames,time_colum,fix_time into names,times,fixs from total where id=' at line 12

展开