[引]mysql帮助文档之cursors游标

<p><font>simple cursors are supported inside stored procedures and functions. <br>the syntax is as in embedded sql. cursors are currently asensitive, read-only, and non-scrolling. <br>asensitive means that the server may or may not make a copy of its result table. </font></p><p><font>cursors must be declared before declaring handlers, <br>and variables and conditions must be declared before declaring either cursors or handlers. </font></p><p><font>example: </font></p><p><font>create procedure curdemo()<br>begin<br> declare done int default 0;<br> declare a char(16);<br> declare b,c int;<br> declare cur1 cursor for select id,data from test.t1;<br> declare cur2 cursor for select i from test.t2;<br> declare continue handler for sqlstate '02000' set done = 1;</font></p><p><font> open cur1;<br> open cur2;</font></p><p><font> repeat<br> fetch cur1 into a, b;<br> fetch cur2 into c;<br> if not done then<br> if b < c then<br> insert into test.t3 values (a,b);<br> else<br> insert into test.t3 values (a,c);<br> end if;<br> end if;<br> until done end repeat;</font></p><p><font> close cur1;<br> close cur2;<br>end<br></font></p>