mysql8.0.13 select与set赋值的区别

mysql 5.0与8.0的赋值的区别：

#if
DELIMITER $
DROP PROCEDURE IF EXISTS myp1$
CREATE PROCEDURE myp1(score DOUBLE,OUT grade1 CHAR,OUT grade2 CHAR)
BEGIN 	
	#select grade2 := 'N';#这里没有报错，正常的语句
	IF score >= 90 THEN SET grade1 := 'A';
	ELSEIF score >=80 THEN SET grade1 := 'B';
	 ELSEIF score >=70 THEN SET grade1 := 'C';
	 ELSEIF score >= 60 THEN SET grade1 :='D';
	 ELSE SET grade1 := 'E';
	 END IF;
END$

CALL myp1(86,@a,@b)$
SELECT @a,@b$
结果：