数据库第十二次作业 存储过程(PL/SQL语句集)的应用

mysql> create table stu(
    -> id int (10) primary key not null unique,
    -> name varchar(50) not null,
    -> class varchar(50) not null);

mysql> insert into stu value(1,"Lucy","class1"),
    -> (2,"Tom","class1"),
    -> (3,"Rose","class2");

mysql> 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;/
Query OK, 0 rows affected (0.02 sec)