Sql-存储过程-参数类型-in
CREATE PROCEDURE chegji(IN chji INT)
BEGIN
IF chji>=90 THEN SELECT '优秀';
ELSEIF chji>=80
THEN SELECT '良好';
ELSEIF chji>=60
THEN SELECT '一般';
ELSE SELECT '不及格';
END IF;
END;
CALL chegji(100);
CREATE PROCEDURE chegji(IN chji INT)
BEGIN
IF chji>=90 THEN SELECT '优秀';
ELSEIF chji>=80
THEN SELECT '良好';
ELSEIF chji>=60
THEN SELECT '一般';
ELSE SELECT '不及格';
END IF;
END;
CALL chegji(100);