这里假定你取一个字段 如果多个字段照做create procedure mypro( INOUT name ) as begin declare tmp boolen default true; declare mycursor cursor for select name from T ; declare continue handler for not found set found=false ; open mycursor; fetch mycursor into name; while found do fetch mycursor into name; end while close mycursor end
as begin
declare tmp boolen default true;
declare mycursor cursor for
select name from T ;
declare continue handler for not found
set found=false ;
open mycursor;
fetch mycursor into name;
while found
do
fetch mycursor into name;
end while
close mycursor
end
tmp 改为found