mysql cursor 游标

最新推荐文章于 2023-04-08 14:42:05 发布

TaoLR

最新推荐文章于 2023-04-08 14:42:05 发布

阅读量696

点赞数 1

分类专栏： db 文章标签： float c sql

本文链接：https://blog.csdn.net/lin_credible/article/details/8038730

版权

db 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

cursor

1. declare

eg: declare c1 cursor for ....(sql select salary from employees;)

declare <游标名> cursor for <select语句>;

2. open

eg: open c1;

open <游标名>;

3. operation
eg: loop
fetch c1 into a;
end loop;

fetch <游标名> into <变量1>,<变量2>...

4. close

eg: close c1;

close <游标名>;

举例说明：

delimiter //
create procedure p_11()
begin
 declare c_total float(8,2);
 declare c_name varchar(20);
 declare c_salary float(8,2);
 declare c_comm float(3,2);
 declare c1 cursor for select name, salary, comm from employees;
 declare exit handler for not found
 begin  close c1; end;
 open c1;
 loop 
   fetch c1 into c_name, c_salary, c_comm;
   select ( c_salary * ifnull(c_comm,0) + c_salary ) into c_total from dual;
   update salary set salary=c_total where name=c_name;
 end loop;
 close c1;
end
//
delimiter ;