create table stu(
??? -> id int(10) 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");
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;
-> //
call addcount (@count) //
select @count,@sum //
