mysql 输出参数赋值,mysql输入输出参数存储过程简单使用

DROP TABLE IF EXISTS `stuinfo`;

CREATE TABLE `stuinfo` (

`id` int(11) NOT NULL,

`stuName` varchar(255) NOT NULL,

`stuNo` varchar(255) NOT NULL,

`stuSex` varchar(4) NOT NULL,

`stuAge` int(11) NOT NULL,

`stuSeat` int(11) NOT NULL,

`stuAddress` varchar(255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `stuinfo` VALUES ('1', 'zhangqiuli', 's25301', 'nan', '18', '1', null);

INSERT INTO `stuinfo` VALUES ('2', 'liwencai', 's25302', 'nan', '31', '2', null);

INSERT INTO `stuinfo` VALUES ('3', 'lisiwen', 's25303', 'nv', '22', '3', null);

INSERT INTO `stuinfo` VALUES ('4', 'ouyangjunxiong', 's25304', 'nan', '28', '4', null);

INSERT INTO `stuinfo` VALUES ('5', 'meichaomeng', 's25318', 'nv', '23', '5', null);

DROP TABLE IF EXISTS `stumarks`;

CREATE TABLE `stumarks` (

`id` int(11) NOT NULL,

`ExamNo` varchar(255) NOT NULL,

`stuNo` varchar(255) NOT NULL,

`writtenExam` double NOT NULL,

`LabExam` double NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `stumarks` VALUES ('1', 's1', 's25303', '93', '59');

INSERT INTO `stumarks` VALUES ('2', 's2', 's25302', '63', '91');

INSERT INTO `stumarks` VALUES ('3', 's3', 's25301', '90', '83');

INSERT INTO `stumarks` VALUES ('4', 's4', 's25318', '63', '53');

存储过程

use test;

drop procedure if exists `pro_use`;

create procedure pro_use (writtenPass int,labPass int,out outputParam varchar(16))//注意这里的变量不需要@，区分于SqlServer

begin

select @aa:=stuName ,stuInfo.stuNo,writtenExam,labExam from stuInfo

inner join stuMarks on stuInfo.stuNo=stuMarks.stuNo

where writtenExam&l