DELIMITER $$
CREATE PROCEDURE `ifexist`(sid_in INT,snum_in INT,sname_in VARCHAR(50),spro_in VARCHAR(50),sgrade_in VARCHAR(50),xmpysx_in VARCHAR(50))
BEGIN
IF NOT EXISTS(
SELECT * FROM `学生表` WHERE snum=snum_in
)
THEN
INSERT INTO `学生表` VALUES(sid ,snum ,sname,spro,sgrade,xmpysx);
ELSEIF EXISTS
(SELECT * FROM `学生表` WHERE snum=snum_in) THEN
SELECT '已存在';
END IF;
END$$
DELIMITER ;