请教一个关于存储过程的问题？？求大神！！！

[BeyondQqiang]

这个存储过程的目的只是为了从一张表中检索出id值然后插入到在存储过程中建立的那张表中。没别的意思，就是在学习游标。

这是要检索表的数据：


这个是存储过程代码：

drop table if exists resT;
delimiter $$
drop procedure if exists pro1 $$
create procedure pro1()
begin
	declare s int;
	declare done boolean default 0;
	declare orderbumbers cursor
	for
	select id from t;
	declare continue handler for sqlstate '02000' set done = 1;
	create table if not exists test2.resT(id int);
	open orderbumbers;
	repeat
		if not done then
			fetch orderbumbers into s;
			insert into resT values ( s );
		end if;
	until done end repeat;
	close orderbumbers;
end $$
delimiter ;

call pro1();
select * from rest;

然后这个是从新建表中搜索数据的结果：


相信大家，看到这两个结果就知道问题了。
就是在 rest 表中怎么会检索出两个id位2的值呢？？
还有就是请大侠能详细解释下：

declare continue handler for sqlstate '02000' set done = 1;

或者给一篇文章的链接地址。
再次谢谢大家了O(∩_∩)O哈！

[WWWWA]

fetch orderbumbers into s; repeat if not done then insert into resT values ( s ); end if; fetch orderbumbers into s; until done end repeat; or fetch orderbumbers into s; while done=0 do ... fetch orderbumbers into s; end while;

[ACMAIN_CHM]

drop table if exists resT; delimiter $$ drop procedure if exists pro1 $$ create procedure pro1() begin declare s int; declare done boolean default 0; declare orderbumbers cursor for select id from t; declare continue handler for sqlstate '02000' set done = 1; create table if not exists test2.resT(id int); open orderbumbers; repeat fetch orderbumbers into s; if not done then insert into resT values ( s ); end if; until done end repeat; close orderbumbers; end $$ delimiter ; call pro1();

[BeyondQqiang]

好吧，谢谢大家了。我了解了。