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