Êý¾Ý¿â ¶à±í ²éѯÁ·Ï°Ìâ

<div class="blogpost-body cnblogs-markdown" id="cnblogs_post_body">
<h1 id="Êý¾Ý¿â½á¹¹´úÂë">Êý¾Ý¿â½á¹¹´úÂë</h1>
<pre class="blockcode"><code class="language-sql"><code>/*
Êý¾Ýµ¼Èë：
Navicat Premium Data Transfer

Source Server         : localhost
Source Server Type    : MySQL
Source Server Version : 50624
Source Host           : localhost
Source Database       : sqlexam

Target Server Type    : MySQL
Target Server Version : 50624
File Encoding         : utf-8

Date: 10/21/2016 06:46:46 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS &#61; 0;

-- ----------------------------
--  Table structure for &#96;class&#96;
-- ----------------------------
DROP TABLE IF EXISTS &#96;class&#96;;
CREATE TABLE &#96;class&#96; (
  &#96;cid&#96; int(11) NOT NULL AUTO_INCREMENT,
  &#96;caption&#96; varchar(32) NOT NULL,
  PRIMARY KEY (&#96;cid&#96;)
) ENGINE&#61;InnoDB AUTO_INCREMENT&#61;5 DEFAULT CHARSET&#61;utf8;

-- ----------------------------
--  Records of &#96;class&#96;
-- ----------------------------
BEGIN;
INSERT INTO &#96;class&#96; VALUES (&#39;1&#39;, &#39;ÈýÄê¶þ°à&#39;), (&#39;2&#39;, &#39;ÈýÄêÈý°à&#39;), (&#39;3&#39;, &#39;Ò»Äê¶þ°à&#39;), (&#39;4&#39;, &#39;¶þÄê¾Å°à&#39;);
COMMIT;

-- ----------------------------
--  Table structure for &#96;course&#96;
-- ----------------------------
DROP TABLE IF EXISTS &#96;course&#96;;
CREATE TABLE &#96;course&#96; (
  &#96;cid&#96; int(11) NOT NULL AUTO_INCREMENT,
  &#96;cname&#96; varchar(32) NOT NULL,
  &#96;teacher_id&#96; int(11) NOT NULL,
  PRIMARY KEY (&#96;cid&#96;),
  KEY &#96;fk_course_teacher&#96; (&#96;teacher_id&#96;),
  CONSTRAINT &#96;fk_course_teacher&#96; FOREIGN KEY (&#96;teacher_id&#96;) REFERENCES &#96;teacher&#96; (&#96;tid&#96;)
) ENGINE&#61;InnoDB AUTO_INCREMENT&#61;5 DEFAULT CHARSET&#61;utf8;

-- ----------------------------
--  Records of &#96;course&#96;
-- ----------------------------
BEGIN;
INSERT INTO &#96;course&#96; VALUES (&#39;1&#39;, &#39;ÉúÎï&#39;, &#39;1&#39;), (&#39;2&#39;, &#39;ÎïÀí&#39;, &#39;2&#39;), (&#39;3&#39;, &#39;ÌåÓý&#39;, &#39;3&#39;), (&#39;4&#39;, &#39;ÃÀÊõ&#39;, &#39;2&#39;);
COMMIT;

-- ----------------------------
--  Table structure for &#96;score&#96;
-- ----------------------------
DROP TABLE IF EXISTS &#96;score&#96;;
CREATE TABLE &#96;score&#96; (
  &#96;sid&#96; int(11) NOT NULL AUTO_INCREMENT,
  &#96;student_id&#96; int(11) NOT NULL,
  &#96;course_id&#96; int(11) NOT NULL,
  &#96;num&#96; int(11) NOT NULL,
  PRIMARY KEY (&#96;sid&#96;),
  KEY &#96;fk_score_student&#96; (&#96;student_id&#96;),
  KEY &#96;fk_score_course&#96; (&#96;course_id&#96;),
  CONSTRAINT &#96;fk_score_course&#96; FOREIGN KEY (&#96;course_id&#96;) REFERENCES &#96;course&#96; (&#96;cid&#96;),
  CONSTRAINT &#96;fk_score_student&#96; FOREIGN KEY (&#96;student_id&#96;) REFERENCES &#96;student&#96; (&#96;sid&#96;)
) ENGINE&#61;InnoDB AUTO_INCREMENT&#61;53 DEFAULT CHARSET&#61;utf8;

-- ----------------------------
--  Records of &#96;score&#96;
-- ----------------------------
BEGIN;
INSERT INTO &#96;score&#96; VALUES (&#39;1&#39;, &#39;1&#39;, &#39;1&#39;, &#39;10&#39;), (&#39;2&#39;, &#39;1&#39;, &#39;2&#39;, &#39;9&#39;), (&#39;5&#39;, &#39;1&#39;, &#39;4&#39;, &#39;66&#39;), (&#39;6&#39;, &#39;2&#39;, &#39;1&#39;, &#39;8&#39;), (&#39;8&#39;, &#39;2&#39;, &#39;3&#39;, &#39;68&#39;), (&#39;9&#39;, &#39;2&#39;, &#39;4&#39;, &#39;99&#39;), (&#39;10&#39;, &#39;3&#39;, &#39;1&#39;, &#39;77&#39;), (&#39;11&#39;, &#39;3&#39;, &#39;2&#39;, &#39;66&#39;), (&#39;12&#39;, &#39;3&#39;, &#39;3&#39;, &#39;87&#39;), (&#39;13&#39;, &#39;3&#39;, &#39;4&#39;, &#39;99&#39;), (&#39;14&#39;, &#39;4&#39;, &#39;1&#39;, &#39;79&#39;), (&#39;15&#39;, &#39;4&#39;, &#39;2&#39;, &#39;11&#39;), (&#39;16&#39;, &#39;4&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;17&#39;, &#39;4&#39;, &#39;4&#39;, &#39;100&#39;), (&#39;18&#39;, &#39;5&#39;, &#39;1&#39;, &#39;79&#39;), (&#39;19&#39;, &#39;5&#39;, &#39;2&#39;, &#39;11&#39;), (&#39;20&#39;, &#39;5&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;21&#39;, &#39;5&#39;, &#39;4&#39;, &#39;100&#39;), (&#39;22&#39;, &#39;6&#39;, &#39;1&#39;, &#39;9&#39;), (&#39;23&#39;, &#39;6&#39;, &#39;2&#39;, &#39;100&#39;), (&#39;24&#39;, &#39;6&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;25&#39;, &#39;6&#39;, &#39;4&#39;, &#39;100&#39;), (&#39;26&#39;, &#39;7&#39;, &#39;1&#39;, &#39;9&#39;), (&#39;27&#39;, &#39;7&#39;, &#39;2&#39;, &#39;100&#39;), (&#39;28&#39;, &#39;7&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;29&#39;, &#39;7&#39;, &#39;4&#39;, &#39;88&#39;), (&#39;30&#39;, &#39;8&#39;, &#39;1&#39;, &#39;9&#39;), (&#39;31&#39;, &#39;8&#39;, &#39;2&#39;, &#39;100&#39;), (&#39;32&#39;, &#39;8&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;33&#39;, &#39;8&#39;, &#39;4&#39;, &#39;88&#39;), (&#39;34&#39;, &#39;9&#39;, &#39;1&#39;, &#39;91&#39;), (&#39;35&#39;, &#39;9&#39;, &#39;2&#39;, &#39;88&#39;), (&#39;36&#39;, &#39;9&#39;, &#39;3&#39;, &#39;67&#39;), (&#39;37&#39;, &#39;9&#39;, &#39;4&#39;, &#39;22&#39;), (&#39;38&#39;, &#39;10&#39;, &#39;1&#39;, &#39;90&#39;), (&#39;39&#39;, &#39;10&#39;, &#39;2&#39;, &#39;77&#39;), (&#39;40&#39;, &#39;10&#39;, &#39;3&#39;, &#39;43&#39;), (&#39;41&#39;, &#39;10&#39;, &#39;4&#39;, &#39;87&#39;), (&#39;42&#39;, &#39;11&#39;, &#39;1&#39;, &#39;90&#39;), (&#39;43&#39;, &#39;11&#39;, &#39;2&#39;, &#39;77&#39;), (&#39;44&#39;, &#39;11&#39;, &#39;3&#39;, &#39;43&#39;), (&#39;45&#39;, &#39;11&#39;, &#39;4&#39;, &#39;87&#39;), (&#39;46&#39;, &#39;12&#39;, &#39;1&#39;, &#39;90&#39;), (&#39;47&#39;, &#39;12&#39;, &#39;2&#39;, &#39;77&#39;), (&#39;48&#39;, &#39;12&#39;, &#39;3&#39;, &#39;43&#39;), (&#