深圳全飞鸿

标题: mysql中游标用法cursor [打印本页]

---

作者: admin    时间: 2019-6-5 15:33
标题: mysql中游标用法cursor
mysql中游标用法

游标的定义：

1.    DECLARE this_input CURSOR FOR
   
2.       SELECT data6, data3 FROM r_ap_temp
   
3.        WHERE data1 = 'SCADA-TML'
   
4.          AND data2 = g_stationno

复制代码

游标的遍历
  

1. OPEN this_input;
   
2.    read_loop: LOOP
   
3.     FETCH this_input INTO l_this_input, l_sequence;
   
4.    IF stopFlag=1 THEN
   
5.     LEAVE read_loop;
   
6.    END IF;
   
7.    SELECT i,n;
   
8.    END LOOP;
   
9.    CLOSE this_input;

复制代码

---

欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/)

Powered by Discuz! X3.2