delimiter $$
drop procedure if exists P_UpdateCourse;
$$
CREATE PROCEDURE P_UpdateCourse (
pSNM varchar(45),
pResult int
)
BEGIN
DECLARE pSNO INT;
DECLARE pBase INT;
DECLARE CUR1 CURSOR
FOR select SNO from student;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET pSNO = null;
set pBase = 200;
OPEN CUR1;
FETCH CUR1 INTO pSNO;
WHILE (pSNO is not null) DO
update course set score = pBase where SNO = pSNO;
set pBase = pBase + 10;
FETCH CUR1 INTO pSNO;
END WHILE;
CLOSE CUR1;
END
drop procedure if exists P_UpdateCourse;
$$
CREATE PROCEDURE P_UpdateCourse (
pSNM varchar(45),
pResult int
)
BEGIN
DECLARE pSNO INT;
DECLARE pBase INT;
DECLARE CUR1 CURSOR
FOR select SNO from student;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET pSNO = null;
set pBase = 200;
OPEN CUR1;
FETCH CUR1 INTO pSNO;
WHILE (pSNO is not null) DO
update course set score = pBase where SNO = pSNO;
set pBase = pBase + 10;
FETCH CUR1 INTO pSNO;
END WHILE;
CLOSE CUR1;
END
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/166523/viewspace-1061537/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
mySQL 中的游标简单使用
请登录后发表评论
登录
全部评论
