DELIMITER $$
CREATE PROCEDURE AddStuScore(StuXH char(6), StuKCM char(16),StuCJ TINYINT,StuXF TINYINT)
BEGIN
	DECLARE StuKCH varchar(3);
	DECLARE StuCJ2 TINYINT;
	SELECT γ̺ INTO StuKCH from KC where γ=StuKCM;
	SELECT ɼ INTO StuCJ2 from XS_KC where ѧ=StuXH and γ̺=StuKCH;
	IF StuCJ2 IS NULL THEN
	INSERT INTO XS_KC values(StuXH,StuKCH,StuCJ,StuXF);	
	ELSE
		UPDATE XS_KC set ɼ=StuCJ,ѧ=StuXF where ѧ=StuXH and γ̺=StuKCH;
	END IF;
END$$
DELIMITER ;