mysql数据库第十二次作业——存储过程的应用

原创已于 2022-04-26 08:50:23 修改 · 677 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库

于 2022-04-26 08:46:15 首次发布

基础专栏收录该内容

38 篇文章

订阅专栏

create database cunchu;

create table stu(id int,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;

mysql> delimiter $
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;$