需要首先替换掉分号
delimiter $$
delimiter ;
delimiter $$ -- 将分隔符换成$$ CREATE PROCEDURE sp_count_scores ( IN studentId integer, OUT scoreCount integer ) BEGIN SELECT COUNT(id) INTO scoreCount FROM score WHERE candidate_id = studentId; END delimiter ; -- 还原分隔符
多快好省!前端后端,线上线下,名师精讲
更多了解 加: