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
Blog系统作为大家最常接触的互联网东东，在站长群体中几乎人手一博，从知名门户的博客频道，到网络营销专家博客，网民对博客的关注度在不断提高并深化。目前网上免费的blog系统太杂，在此整理PHP版的Blog介绍如下：
1、wordpress:http://www.wordpress.org 功能也很全面，应该是支持blog的首选。它有最强的模版功能，已经 ......
