存储过程常用语句

最新推荐文章于 2024-06-17 15:00:11 发布

kurt1988

最新推荐文章于 2024-06-17 15:00:11 发布

阅读量578

点赞数

本文链接：https://blog.csdn.net/kurt1988/article/details/12772051

版权

BEGIN
-- 声明一个标志done，用来判断游标是否遍历完成
DECLARE Done INT DEFAULT 0;
DECLARE gamename varchar(50);
-- 声明游标对应的 SQL 语句
DECLARE cur_l CURSOR FOR select gname from kfgame where gname != '' group by gname;
-- 在游标循环到最后会将 done 设置为 1
DECLARE CONTINUE HANDLER FOR NOT FOUND SET Done = 1;

delete from gamename_temp;

OPEN cur_l;
REPEAT
FETCH cur_l INTO gamename;
IF Done = 0 THEN
INSERT INTO gamename_temp(gname) VALUES (gamename);
END IF;
UNTIL Done = 1 END REPEAT;
CLOSE cur_l;
END