关于not found和fetch而空的存储过程的异常问题

edwardhey

DELIMITER $$ DROP PROCEDURE IF EXISTS `study`.`test`$$ CREATE PROCEDURE `study`.`test`(out _res int)     /*LANGUAGE SQL     | [NOT] DETERMINISTIC     | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }     | SQL SECURITY { DEFINER | INVOKER }     | COMMENT 'string'*/     BEGIN     declare _host varchar(20);     declare _cur cursor for select HOST from mysql.user where user = 'root';     declare exit handler for 1329 set _res = 1;#定义在fetch没有数据的时候退出     declare exit handler for not found set _res = 2;#在定义没有搜索到记录的时候退出     select HOST into _host from mysql.user where user = 'roo';     END$$ DELIMITER ;

调用的时候

call test(@res); select @res;

输出的是1 而不是2 select没有记录不应该是2么？难道select into 等同于fetch into?望高人解答~

edwardhey