MySQL使用游标

最新推荐文章于 2024-09-20 15:51:56 发布

给算法爸爸上香

最新推荐文章于 2024-09-20 15:51:56 发布

阅读量158

点赞数

分类专栏： MySQL 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/taifyang/article/details/117196251

版权

MySQL 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

创建游标

create procedure processorders()
begin
	declare ordernumbers cursor
	for
	select order_num from orders;
end;

打开游标

open ordernumbers;

关闭游标

close ordernumbers;

使用游标
从游标中检索单个行

create procedure processorders()
begin
	declare ordernumbers cursor
	for
	select order_num from orders;
	open ordernumbers;
	fetch ordernumbers into o;
	close ordernumbers;
end;

循环检索数据

create procedure processorders()
begin
	declare done boolean default o;
	declare 0 int;
	declare ordernumbers cursor
	for
	select order_num from orders;
	declare continue handler for sqlstate '02000' set done = 1;
	open ordernumbers;
	repeat
		fetch ordernumbers into o;
	until done end repeat;
	close ordernumbers;
end;