create table stu (
id int(11) primary key not null unique,
name varchar(50) not null,
class varchar(50) not null
)//
insert into stu value (1,"Lucy","class1"),(2,"Tom","class1"),(3,"Rose","class2")//
delimiter //
create procedure addcount (out count int)
begin
declare itmp int;
declare cur_id cursor for select id from stu;
declare exit handler for not found close cur_id;
select count(*) into count from stu;
set @sum=0;
open cur_id;
repeat
fetch cur_id into itmp;
if itmp<10
then set @sum=@sum+itmp;
end if;
until 0 end repeat;
close cur_id;
end//