1、基本語法： Sql代碼 #定義游標(biāo) declare fetchSeqCursor cursor for select seqname, value from sys_sequence; #使用游標(biāo) open fetchSeqCursor； #fetch數(shù)據(jù) fetch cursor into _seqname, _value; #關(guān)閉游標(biāo) close fetchSeqCursor; 2、單游標(biāo)例子： Sql代

1、基本語法：

Sql代碼

#定義游標(biāo)

declare fetchSeqCursor cursor for select seqname, value from sys_sequence;

#使用游標(biāo)

open fetchSeqCursor；

#fetch數(shù)據(jù)

fetch cursor into _seqname, _value;

#關(guān)閉游標(biāo)

close fetchSeqCursor;

2、單游標(biāo)例子：

Sql代碼

## define the flag for loop judgement

declare fetchSeqOk boolean;

## define the varient for store the data

declare _seqname varchar(50);

declare _value bigint(20);

## define the cursor

declare fetchSeqCursor cursor for select seqname, value from sys_sequence;

## define the continue handler for not found flag

declare continue handler for NOT FOUND set fetchSeqOk = true;

set fetchSeqOk = false;

open fetchSeqCursor;

fetchSeqLoop:Loop

if fetchSeqOk then

leave fetchSeqLoop;

else

fetch cursor into _seqname, _value;

select _seqname, _value;

end if;

end Loop;

close fetchSeqCursor;

3、嵌套的游標(biāo)循環(huán)

Java代碼

## define the flag for loop judgement

declare fetchSeqOk boolean;

## define the varient for store the data

declare _seqname varchar(50);

declare _value bigint(20);

## define the cursor

declare fetchSeqCursor cursor for select seqname, value from sys_sequence;

## define the continue handler for not found flag

declare continue handler for NOT FOUND set fetchSeqOk = true;

set fetchSeqOk = false;

open fetchSeqCursor;

fetchSeqLoop:Loop

if fetchSeqOk then

leave fetchSeqLoop;

else

fetch cursor into _seqname, _value;

#嵌套的游標(biāo)循環(huán)

begin

declare fetchSeqOk boolean default 'inner';

## define the cursor

declare cursor2 cursor for select .... from ...;

## define the continue handler for not

declare continue handler for NOT FOUND set fetchSeqOk = true;

set fetchSeqOk = false;

open cursor2;

fetchloop2 loop

if fetchSeqOk then

else

end if;

end loop;

close cursor2;

end;

#嵌套的游標(biāo)循環(huán)結(jié)束

end if;

end Loop;

close fetchSeqCursor;

總結(jié)

以上是生活随笔為你收集整理的mysql游标事例_MySQL游标语法实例的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。