create procedure percent_pro(out percent float(2) )
begin
DECLARE num , sum ,i integer;
declare edu char(4);
declare percent_cursor cursor for
select Education
FROM employee;
open percent_cursor;
fetch percent_cursor into edu;
set i=0;
set sum=(select count(*)
from employee);
set num=sum;
while i<sum 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;
这段代码有何错误,为何编译通过,可一选择调用就出现没有获取,修改一行数据