1、任务实施内容
1.1 创建游标
1.2 使用游标
2、任务实施步骤
1.1 创建游标
mysql> delimiter $$
mysql> create procedure p_cursor()
-> begin
-> declare orsum int;
-> declare ostatus char(8);
-> declare sum int default 0;
-> declare flag int default0;
-> declare cur cursor forselect o_status,o_sum from orders where o_status ='已完结';
-> declare continue handlerfor not found set flag=1;
-> set sum=0;
-> open cur;
-> fetch cur intoostatus,orsum;
-> while(flag=0) do
-> set sum=sum+orsum;
-> fetch cur intoostatus,orsum;
-> end while;
-> close cur;
-> select sum;
-> end
-> $$
Query OK, 0 rows affected
1.2 使用游标
mysql> call p_cursor();
执行结果如下：
+-------+
|sum |
+-------+
|34205 |
+-------+
