MySQL数据库第十一次

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 //