CREATE PROCEDURE get_stu_avg_scorel (stuno char(12),OUT grade FLOAT) SELECT ROUND(AVG(choose.score),2) into grade FROM choose WHERE student_id=stuno; SET @avg_score=0; call get_stu_avg_scorel ('201710201102',@avg_score); SELECT @avg_score as 平均分;