DELIMITER $$
CREATE PROCEDURE `StudentSys`.`returnStudentInfo(
OUT @sName INT,
OUT @sSex INT,
OUT @sAge INT,
OUT @sClass IVARCHAR(50),
OUT @sCHome INT,
@sId INT
) BEGIN
-- 其他sql语句 END$$DELIMITER ;-------------------
提示如下错误:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@sName int ,
OUT @sSex int ,
OUT @sAge int ,
OUT @sC' at line 2
CREATE PROCEDURE `StudentSys`.`returnStudentInfo(
OUT @sName INT,
OUT @sSex INT,
OUT @sAge INT,
OUT @sClass IVARCHAR(50),
OUT @sCHome INT,
@sId INT
) BEGIN
-- 其他sql语句 END$$DELIMITER ;-------------------
提示如下错误:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@sName int ,
OUT @sSex int ,
OUT @sAge int ,
OUT @sC' at line 2
CREATE PROCEDURE `returnStudentInfo`(OUT sName INT,OUT sSex INT,OUT sAge INT,OUT sClass VARCHAR(50),OUT sCHome INT,sId INT)
BEGIN
END$$DELIMITER ;