create procedure percent_pro(out percent float(2) )
begin
DECLARE num , sum ,i integer;
declare edu char(4);
declare flag integer default 1;
declare percent_cursor cursor for
select Education
FROM employee;
declare continue handler for not found
set flag=0;
open percent_cursor;
fetch percent_cursor into edu;
set i=0;
set sum=(select count(*)
from employee);
set num=sum;
while i<sum and flag=1 do
if edu='大专'
then set num=num-1;
end if;
set i=i+1;
fetch percent_cursor into edu;
end while;
close percent_cursor;
set percent=num/sum;
end;
在游标定义后面添加declare continue handler for not found set flag=0即可得出结论