mysql中游标用法cursor

admin

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;

复制代码