在使用MySQL的存储过程时,系统报错,不知道原因。
程序如下:
USE db_school;
DELIMITER $$
CREATE PROCEDURE sp_sumofrow(OUT ROWS INT)
BEGIN
DECLARE sno CHAR;
DECLARE FOUND BOOLEAN DEFAULT TRUE;
DECLARE cur CURSOR FOR
SELECT studentNo FROM tb_student;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET FOUND = FALSE;
SET ROWS = 0;
OPEN cur;
FETCH cur INTO sno;
WHILE FOUND DO
SET ROWS = ROWS + 1;
FETCH cur INTO sno;
END WHILE;
CLOSE cur;
END $$
DELIMITER ;