create tableliufeng_stu(
-> id int(10) not null,
-> name varchar(50) not null,
-> class varchar(50) not null,
-> primary key(id)
-> );
insert into liufeng_stu values
-> (1,"Luck","calss1"),
-> (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 xu;
-> declare exit handler for not found close cur_id;
-> select count(*) into count from xu;
-> 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//