MySQL存储过程,和游标相关,急
Cain 2008-09-17 11:56:00 BEGIN
DECLARE _id, flag INT;
DECLARE foo VARCHAR(200) DEFAULT '|';
DECLARE cur_1 CURSOR FOR SELECT cateId FROM cate WHERE cateId < 2 ORDER BY cateId;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag = 1;
OPEN cur_1;
REPEAT
FETCH cur_1 INTO _id;
SET foo = CONCAT(foo, '|', _id);
UNTIL flag
END REPEAT;
CLOSE cur_1;
SELECT foo;
END
运行结果:
||1|1
问题:
为什么输出会有2个1,理论上来说应该是||1这样的结果,是不是我对循环的理解错了?