MySQL 相关项目
现在是这样写的：
DECLARE cur CURSOR FOR SELECT name FROM tb;
OPEN cur;
lbl1: LOOP
FETCH cur INTO temp;
IF done=1 THEN
LEAVE lbl1;
END IF;
END LOOP;
CLOSE cur;
请问不用游标，直接循环结果集，怎么写呢？
DECLARE cur CURSOR FOR SELECT name FROM tb;
OPEN cur;
lbl1: LOOP
FETCH cur INTO temp;
IF done=1 THEN
LEAVE lbl1;
END IF;
END LOOP;
CLOSE cur;
请问不用游标，直接循环结果集，怎么写呢？
Select Language