create database guochangsheng_chapter06;
create table stu(
id int(10) primary key unique,
name varchar(50) not null,
class varchar(50) not null
);
insert into stu values
("1","Lucy","class1"),
("2","Tom","class1"),
("3","Rose","class2");
desc stu;
select * from stu;
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//