MySQL学习——创建查询用表 

  1 /*********************************************************
  2 第四章 DQL查询数据（重点！！！）
  3 4.1：DQL
  4 p16：基本的Select语句和别名使用
  5 time：12:26
  6 *********************************************************/
  7 
  8 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `school`/* !40100 DEFAULT CHARACTER SET utf8 */;
  9 USE school;
 10 
 11 /*1：Table structure for table `grade`*/
 12 DROP TABLE IF EXISTS `grade`;
 13 
 14 CREATE TABLE `grade`(
 15     `GradeID` INT(11) NOT NULL AUTO_INCREMENT COMMENT '年级编号',
 16     `GradeName` VARCHAR(50) NOT NULL COMMENT '年级名称',
 17     PRIMARY KEY (`GradeID`)
 18 )ENGINE=INNODB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 19 
 20 /*1：Data for the table `grade`*/
 21 INSERT INTO `grade`(`GradeID`,`GradeName`) VALUES(1,'大一'),(2,'大二'),(3,'大三'),(4,'大四'),(5,'预科班');
 22 
 23 
 24 /*2：Table structure for table `result`*/
 25 
 26 DROP TABLE IF EXISTS `result`;
 27 CREATE TABLE `result`(
 28     `StudentNo` INT(4) NOT NULL COMMENT '学号',
 29     `SubjectNo` INT(4) NOT NULL COMMENT '课程编号',
 30     `ExamDate` DATETIME NOT NULL COMMENT '考试日期',
 31     `StudentResult` INT(4) NOT NULL COMMENT '考试成绩',
 32     KEY `StudentNo`(`StudentNo`)
 33 )ENGINE=INNODB DEFAULT CHARSET=utf8;
 34 
 35 /*2：Data for the table `result`*/
 36 INSERT INTO `result`(`StudentNo`,`SubjectNo`,`ExamDate`,`StudentResult`) 
 37 VALUES(1000,1,'2013-11-11 16:00:00',94),
 38 (1000,2,'2012-11-10 10:00:00',75),
 39 (1000,3,'2011-12-19 10:00:00',76),
 40 (1000,4,'2010-11-18 11:00:00',93),
 41 (1000,5,'2013-11-11 14:00:00',97),
 42 (1000,6,'2012-09-13 15:00:00',87),
 43 (1000,7,'2011-10-16 16:00:00',79),
 44 (1000,8,'2010-11-11 16:00:00',74),
 45 (1000,9,'2013-11-21 10:00:00',69),
 46 (1000,10,'2012-11-11 12:00:00',78),
 47 (1000,11,'2011-11-11 14:00:00',66),
 48 (1000,12,'2010-11-11 15:00:00',82),
 49 (1000,13,'2013-11-11 14:00:00',94),
 50 (1000,14,'2012-11-11 15:00:00',98),
 51 (1000,15,'2011-12-11 10:00:00',70),
 52 (1000,16,'2010-09-11 10:00:00',74),
 53 
 54 (1001,1,'2013-11-11 16:00:00',76),
 55 (1001,2,'2012-11-10 10:00:00',93),
 56 (1001,3,'2011-12-19 10:00:00',65),
 57 (1001,4,'2010-11-18 11:00:00',71),
 58 (1001,5,'2013-11-11 14:00:00',98),
 59 (1001,6,'2012-09-13 15:00:00',74),
 60 (1001,7,'2011-10-16 16:00:00',85),
 61 (1001,8,'2010-11-11 16:00:00',69),
 62 (1001,9,'2013-11-21 10:00:00',63),
 63 (1001,10,'2012-11-11 12:00:00',70),
 64 (1001,11,'2011-11-11 14:00:00',62),
 65 (1001,12,'2010-11-11 15:00:00',90),
 66 (1001,13,'2013-11-11 14:00:00',97),
 67 (1001,14,'2012-11-11 15:00:00',89),
 68 (1001,15,'2011-12-11 10:00:00',72),
 69 (1001,16,'2010-09-11 10:00:00',90),
 70 
 71 (1002,1,'2013-11-11 16:00:00',60),
 72 (1002,2,'2012-11-10 10:00:00',80),
 73 (1002,3,'2011-12-19 10:00:00',89),
 74 (1002,4,'2010-11-18 11:00:00',88),
 75 (1002,5,'2013-11-11 14:00:00',82),
 76 (1002,6,'2012-09-13 15:00:00',91),
 77 (1002,7,'2011-10-16 16:00:00',63),
 78 (1002,8,'2010-11-11 16:00:00',84),
 79 (1002,9,'2013-11-21 10:00:00',60),
 80 (1002,10,'2012-11-11 12:00:00',71),
 81 (1002,11,'2011-11-11 14:00:00',93),
 82 (1002,12,'2010-11-11 15:00:00',96),
 83 (1002,13,'2013-11-11 14:00:00',83),
 84 (1002,14,'2012-11-11 15:00:00',69),
 85 (1002,15,'2011-12-11 10:00:00',89),
 86 (1002,16,'2010-09-11 10:00:00',83),
 87 
 88 
 89 (1003,1,'2013-11-11 16:00:00',91),
 90 (1003,2,'2012-11-10 10:00:00',75),
 91 (1003,3,'2011-12-19 10:00:00',65),
 92 (1003,4,'2010-11-18 11:00:00',63),
 93 (1003,5,'2013-11-11 14:00:00',90),
 94 (1003,6,'2012-09-13 15:00:00',96),
 95 (1003,7,'2011-10-16 16:00:00',97),
 96 (1003,8,'2010-11-11 16:00:00',77),
 97 (1003,9,'2013-11-21 10:00:00',62),
 98 (1003,10,'2012-11-11 12:00:00',81),
 99 (1003,11,'2011-11-11 14:00:00',76),
100 (1003,12,'2010-11-11 15:00:00',61),
101 (1003,13,'2013-11-11 14:00:00',93),
102 (1003,14,'2012-11-11 15:00:00',79),
103 (1003,15,'2011-12-11 10:00:00',78),
104 (1003,16,'2010-09-11 10:00:00',96),
105 
106 
107 
108 (1004,1,'2013-11-11 16:00:00',84),
109 (1004,2,'2012-11-10 10:00:00',79),
110 (1004,3,'2011-12-19 10:00:00',76),
111 (1004,4,'2010-11-18 11:00:00',78),
112 (1004,5,'2013-11-11 14:00:00',81),
113 (1004,6,'2012-09-13 15:00:00',90),
114 (1004,7,'2011-10-16 16:00:00',63),
115 (1004,8,'2010-11-11 16:00:00',89),
116 (1004,9,'2013-11-21 10:00:00',67),
117 (1004,10,'2012-11-11 12:00:00',100),
118 (1004,11,'2011-11-11 14:00:00',94),
119 (1004,12,'2010-11-11 15:00:00',65),
120 (1004,13,'2013-11-11 14:00:00',86),
121 (1004,14,'2012-11-11 15:00:00',77),
122 (1004,15,'2011-12-11 10:00:00',82),
123 (1004,16,'2010-09-11 10:00:00',87),
124 
125 
126 (1005,1,'2013-11-11 16:00:00',80),
127 (1005,2,'2012-11-10 10:00:00',92),
128 (1005,3,'2011-12-19 10:00:00',80),
129 (1005,4,'2010-11-18 11:00:00',92),
130 (1005,5,'2013-11-11 14:00:00',97),
131 (1005,6,'2012-09-13 15:00:00',72),
132 (1005,7,'2011-10-16 16:00:00',84),
133 (1005,8,'2010-11-11 16:00:00',79),
134 (1005,9,'2013-11-21 10:00:00',76),
135 (1005,10,'2012-11-11 12:00:00',87),
136 (1005,11,'2011-11-11 14:00:00',65),
137 (1005,12,'2010-11-11 15:00:00',67),
138 (1005,13,'2013-11-11 14:00:00',63),
139 (1005,14,'2012-11-11 15:00:00',64),
140 (1005,15,'2011-12-11 10:00:00',99),
141 (1005,16,'2010-09-11 10:00:00',97),
142 
143 
144 (1006,1,'2013-11-11 16:00:00',82),
145 (1006,2,'2012-11-10 10:00:00',73),
146 (1006,3,'2011-12-19 10:00:00',79),
147 (1006,4,'2010-11-18 11:00:00',63),
148 (1006,5,'2013-11-11 14:00:00',97),
149 (1006,6,'2012-09-13 15:00:00',83),
150 (1006,7,'2011-10-16 16:00:00',78),
151 (1006,8,'2010-11-11 16:00:00',88),
152 (1006,9,'2013-11-21 10:00:00',89),
153 (1006,10,'2012-11-11 12:00:00',82),
154 (1006,11,'2011-11-11 14:00:00',70),
155 (1006,12,'2010-11-11 15:00:00',69),
156 (1006,13,'2013-11-11 14:00:00',64),
157 (1006,14,'2012-11-11 15:00:00',80),
158 (1006,15,'2011-12-11 10:00:00',89),
159 (1006,16,'2010-09-11 10:00:00',85),
160 
161 
162 (1007,1,'2013-11-11 16:00:00',87),
163 (1007,2,'2012-11-10 10:00:00',63),
164 (1007,3,'2011-12-19 10:00:00',70),
165 (1007,4,'2010-11-18 11:00:00',74),
166 (1007,5,'2013-11-11 14:00:00',79),
167 (1007,6,'2012-09-13 15:00:00',83),
168 (1007,7,'2011-10-16 16:00:00',86),
169 (1007,8,'2010-11-11 16:00:00',76),
170 (1007,9,'2013-11-21 10:00:00',65),
171 (1007,10,'2012-11-11 12:00:00',87),
172 (1007,11,'2011-11-11 14:00:00',69),
173 (1007,12,'2010-11-11 15:00:00',69),
174 (1007,13,'2013-11-11 14:00:00',90),
175 (1007,14,'2012-11-11 15:00:00',84),
176 (1007,15,'2011-12-11 10:00:00',95),
177 (1007,16,'2010-09-11 10:00:00',92),
178 
179 
180 (1008,1,'2013-11-11 16:00:00',96),
181 (1008,2,'2012-11-10 10:00:00',62),
182 (1008,3,'2011-12-19 10:00:00',97),
183 (1008,4,'2010-11-18 11:00:00',84),
184 (1008,5,'2013-11-11 14:00:00',86),
185 (1008,6,'2012-09-13 15:00:00',72),
186 (1008,7,'2011-10-16 16:00:00',67),
187 (1008,8,'2010-11-11 16:00:00',83),
188 (1008,9,'2013-11-21 10:00:00',86),
189 (1008,10,'2012-11-11 12:00:00',60),
190 (1008,11,'2011-11-11 14:00:00',61),
191 (1008,12,'2010-11-11 15:00:00',68),
192 (1008,13,'2013-11-11 14:00:00',99),
193 (1008,14,'2012-11-11 15:00:00',77),
194 (1008,15,'2011-12-11 10:00:00',73),
195 (1008,16,'2010-09-11 10:00:00',78),
196 
197 (1009,1,'2013-11-11 16:00:00',67),
198 (1009,2,'2012-11-10 10:00:00',70),
199 (1009,3,'2011-12-19 10:00:00',75),
200 (1009,4,'2010-11-18 11:00:00',92),
201 (1009,5,'2013-11-11 14:00:00',76),
202 (1009,6,'2012-09-13 15:00:00',90),
203 (1009,7,'2011-10-16 16:00:00',62),
204 (1009,8,'2010-11-11 16:00:00',68),
205 (1009,9,'2013-11-21 10:00:00',70),
206 (1009,10,'2012-11-11 12:00:00',83),
207 (1009,11,'2011-11-11 14:00:00',88),
208 (1009,12,'2010-11-11 15:00:00',65),
209 (1009,13,'2013-11-11 14:00:00',91),
210 (1009,14,'2012-11-11 15:00:00',99),
211 (1009,15,'2011-12-11 10:00:00',65),
212 (1009,16,'2010-09-11 10:00:00',83),
213 
214 (1010,1,'2013-11-11 16:00:00',83),
215 (1010,2,'2012-11-10 10:00:00',87),
216 (1010,3,'2011-12-19 10:00:00',89),
217 (1010,4,'2010-11-18 11:00:00',99),
218 (1010,5,'2013-11-11 14:00:00',91),
219 (1010,6,'2012-09-13 15:00:00',96),
220 (1010,7,'2011-10-16 16:00:00',72),
221 (1010,8,'2010-11-11 16:00:00',72),
222 (1010,9,'2013-11-21 10:00:00',98),
223 (1010,10,'2012-11-11 12:00:00',73),
224 (1010,11,'2011-11-11 14:00:00',68),
225 (1010,12,'2010-11-11 15:00:00',62),
226 (1010,13,'2013-11-11 14:00:00',67),
227 (1010,14,'2012-11-11 15:00:00',69),
228 (1010,15,'2011-12-11 10:00:00',71),
229 (1010,16,'2010-09-11 10:00:00',66),
230 
231 
232 
233 (1011,1,'2013-11-11 16:00:00',62),
234 (1011,2,'2012-11-10 10:00:00',72),
235 (1011,3,'2011-12-19 10:00:00',96),
236 (1011,4,'2010-11-18 11:00:00',64),
237 (1011,5,'2013-11-11 14:00:00',89),
238 (1011,6,'2012-09-13 15:00:00',91),
239 (1011,7,'2011-10-16 16:00:00',95),
240 (1011,8,'2010-11-11 16:00:00',96),
241 (1011,9,'2013-11-21 10:00:00',89),
242 (1011,10,'2012-11-11 12:00:00',73),
243 (1011,11,'2011-11-11 14:00:00',82),
244 (1011,12,'2010-11-11 15:00:00',98),
245 (1011,13,'2013-11-11 14:00:00',66),
246 (1011,14,'2012-11-11 15:00:00',69),
247 (1011,15,'2011-12-11 10:00:00',91),
248 (1011,16,'2010-09-11 10:00:00',69),
249 
250 
251 (1012,1,'2013-11-11 16:00:00',86),
252 (1012,2,'2012-11-10 10:00:00',66),
253 (1012,3,'2011-12-19 10:00:00',97),
254 (1012,4,'2010-11-18 11:00:00',69),
255 (1012,5,'2013-11-11 14:00:00',70),
256 (1012,6,'2012-09-13 15:00:00',74),
257 (1012,7,'2011-10-16 16:00:00',91),
258 (1012,8,'2010-11-11 16:00:00',97),
259 (1012,9,'2013-11-21 10:00:00',84),
260 (1012,10,'2012-11-11 12:00:00',82),
261 (1012,11,'2011-11-11 14:00:00',90),
262 (1012,12,'2010-11-11 15:00:00',91),
263 (1012,13,'2013-11-11 14:00:00',91),
264 (1012,14,'2012-11-11 15:00:00',97),
265 (1012,15,'2011-12-11 10:00:00',85),
266 (1012,16,'2010-09-11 10:00:00',90),
267 
268 
269 
270 (1013,1,'2013-11-11 16:00:00',73),
271 (1013,2,'2012-11-10 10:00:00',69),
272 (1013,3,'2011-12-19 10:00:00',91),
273 (1013,4,'2010-11-18 11:00:00',72),
274 (1013,5,'2013-11-11 14:00:00',76),
275 (1013,6,'2012-09-13 15:00:00',87),
276 (1013,7,'2011-10-16 16:00:00',61),
277 (1013,8,'2010-11-11 16:00:00',77),
278 (1013,9,'2013-11-21 10:00:00',83),
279 (1013,10,'2012-11-11 12:00:00',99),
280 (1013,11,'2011-11-11 14:00:00',91),
281 (1013,12,'2010-11-11 15:00:00',84),
282 (1013,13,'2013-11-11 14:00:00',90),
283 (1013,14,'2012-11-11 15:00:00',74),
284 (1013,15,'2011-12-11 10:00:00',92),
285 (1013,16,'2010-09-11 10:00:00',90),
286 
287 
288 (1014,1,'2013-11-11 16:00:00',64),
289 (1014,2,'2012-11-10 10:00:00',81),
290 (1014,3,'2011-12-19 10:00:00',79),
291 (1014,4,'2010-11-18 11:00:00',74),
292 (1014,5,'2013-11-11 14:00:00',65),
293 (1014,6,'2012-09-13 15:00:00',88),
294 (1014,7,'2011-10-16 16:00:00',86),
295 (1014,8,'2010-11-11 16:00:00',77),
296 (1014,9,'2013-11-21 10:00:00',86),
297 (1014,10,'2012-11-11 12:00:00',85),
298 (1014,11,'2011-11-11 14:00:00',86),
299 (1014,12,'2010-11-11 15:00:00',75),
300 (1014,13,'2013-11-11 14:00:00',89),
301 (1014,14,'2012-11-11 15:00:00',79),
302 (1014,15,'2011-12-11 10:00:00',73),
303 (1014,16,'2010-09-11 10:00:00',68),
304 
305 
306 
307 
308 (1015,1,'2013-11-11 16:00:00',99),
309 (1015,2,'2012-11-10 10:00:00',60),
310 (1015,3,'2011-12-19 10:00:00',60),
311 (1015,4,'2010-11-18 11:00:00',75),
312 (1015,5,'2013-11-11 14:00:00',78),
313 (1015,6,'2012-09-13 15:00:00',78),
314 (1015,7,'2011-10-16 16:00:00',84),
315 (1015,8,'2010-11-11 16:00:00',95),
316 (1015,9,'2013-11-21 10:00:00',93),
317 (1015,10,'2012-11-11 12:00:00',79),
318 (1015,11,'2011-11-11 14:00:00',74),
319 (1015,12,'2010-11-11 15:00:00',65),
320 (1015,13,'2013-11-11 14:00:00',63),
321 (1015,14,'2012-11-11 15:00:00',74),
322 (1015,15,'2011-12-11 10:00:00',67),
323 (1015,16,'2010-09-11 10:00:00',65),
324 
325 (1016,1,'2013-11-11 16:00:00',97),
326 (1016,2,'2012-11-10 10:00:00',90),
327 (1016,3,'2011-12-19 10:00:00',77),
328 (1016,4,'2010-11-18 11:00:00',75),
329 (1016,5,'2013-11-11 14:00:00',75),
330 (1016,6,'2012-09-13 15:00:00',97),
331 (1016,7,'2011-10-16 16:00:00',96),
332 (1016,8,'2010-11-11 16:00:00',92),
333 (1016,9,'2013-11-21 10:00:00',62),
334 (1016,10,'2012-11-11 12:00:00',83),
335 (1016,11,'2011-11-11 14:00:00',98),
336 (1016,12,'2010-11-11 15:00:00',94),
337 (1016,13,'2013-11-11 14:00:00',62),
338 (1016,14,'2012-11-11 15:00:00',97),
339 (1016,15,'2011-12-11 10:00:00',76),
340 (1016,16,'2010-09-11 10:00:00',82),
341 
342 
343 (1017,1,'2013-11-11 16:00:00',100),
344 (1017,2,'2012-11-10 10:00:00',88),
345 (1017,3,'2011-12-19 10:00:00',86),
346 (1017,4,'2010-11-18 11:00:00',73),
347 (1017,5,'2013-11-11 14:00:00',96),
348 (1017,6,'2012-09-13 15:00:00',64),
349 (1017,7,'2011-10-16 16:00:00',81),
350 (1017,8,'2010-11-11 16:00:00',66),
351 (1017,9,'2013-11-21 10:00:00',76),
352 (1017,10,'2012-11-11 12:00:00',95),
353 (1017,11,'2011-11-11 14:00:00',73),
354 (1017,12,'2010-11-11 15:00:00',82),
355 (1017,13,'2013-11-11 14:00:00',85),
356 (1017,14,'2012-11-11 15:00:00',68),
357 (1017,15,'2011-12-11 10:00:00',99),
358 (1017,16,'2010-09-11 10:00:00',76);
359 
360 /*3：Table structure for table `student`*/
361 
362 DROP TABLE IF EXISTS `student`;
363 
364 
365 CREATE TABLE `student`(
366     `StudentNo` INT(4) NOT NULL COMMENT '学号',
367     `LoginPwd` VARCHAR(20) DEFAULT NULL COMMENT '登录密码',
368     `StudentName` VARCHAR(20) DEFAULT NULL COMMENT '学生姓名',
369     `Sex` TINYINT(1) DEFAULT NULL COMMENT '性别，取值0或1',
370     
371     `GradeID` INT(11) DEFAULT NULL COMMENT '年级编号',
372     `Phone` VARCHAR(50) NOT NULL COMMENT '联系电话，允许为空，即可选输入',
373     `Address` VARCHAR(255) NOT NULL COMMENT '地址，允许为空，即可选输入',
374     `BornDate` DATETIME DEFAULT NULL COMMENT '出生时间',
375     
376     `Email` VARCHAR(50) NOT NULL COMMENT '邮箱账号，允许为空，即可选输入',
377     `IdentityCard` VARCHAR(18) DEFAULT NULL COMMENT '身份证号',
378     PRIMARY KEY(`StudentNo`),
379     UNIQUE KEY `IdentityCard` (`IdentityCard`),
380     KEY `Email` (`Email`)
381 )ENGINE=MYISAM DEFAULT CHARSET=utf8;
382 
383 
384 /*3：Data for the table `student`*/
385 
386 INSERT INTO `student`(`StudentNo`,`LoginPwd`,`StudentName`,`Sex`,`GradeID`,`Phone`,`Address`,`BornDate`,`Email`,`IdentityCard`)
387 VALUES (1000,'111111','周丹',1,1,'13500000001','北京市海淀区中关村大街1号','1986-12-11 00:00:00','test@qq.com','450323198612111234'),
388 (1001,'123456','周颖',1,2,'13500000002','河南洛阳','1986-12-31 00:00:00','test@qq.com','450323198612311234'),
389 (1002,'111111','杨文瑞',1,1,'13500000003','天津市和平区','1986-11-30 00:00:00','test@qq.com','450323198611301234'),
390 (1003,'123456','韩萌',1,3,'13500000004','上海卢湾区','1986-12-31 00:00:00','test@qq.com','450323198612314234'),
391 (1004,'123456','刘丽侠',1,4,'13500000005','北京市通州','1989-12-31 00:00:00','test@qq.com','450323198912311244'),
392 (1005,'123456','姜嘉航',2,1,'13500000006','广西桂林市灵川','1986-12-31 00:00:00','test@qq.com','450323198612311214'),
393 (1006,'123456','郑嘉祥',2,4,'13500000007','地址不详','1986-12-31 00:00:00','test@qq.com','450323198612311134'),
394 (1007,'111111','刘洋',1,1,'13500000008','北京东城区','1986-12-31 00:00:00','test@qq.com','450323198612311133'),
395 (1008,'111111','刘洋洋',1,1,'13500000009','河南洛阳','1986-12-31 00:00:00','test@qq.com','450323198612311221'),
396 (1009,'123456','刘毅',1,2,'13500000011','安徽','1986-12-31 00:00:00','test@qq.com','450323198612311231'),
397 (1010,'111111','赵杰',1,1,'13500000012','河南洛阳','1986-12-31 00:00:00','test@qq.com','450323198612311044'),
398 (1011,'111111','赵成',1,1,'13500000013','北京市海淀区中关村大街*号','1984-12-11 00:00:00','test@qq.com','450323198412111234'),
399 (1012,'123456','刘恒',2,3,'13500000014','广西南宁中央大街','1986-12-31 00:00:00','test@qq.com','450323198612311334'),
400 (1013,'123456','张伟奇',2,1,'13500000015','上海卢湾区','1986-12-31 00:00:00','test@qq.com','450323198612311534'),
401 (1014,'123456','牛恩来',2,4,'13500000016','北京市海淀区中关村大街*号','1986-12-31 00:00:00','test@qq.com','450323198612311264'),
402 (1015,'123456','马辉',1,4,'13500000017','广西桂林市灵川','1976-12-31 00:00:00','test@qq.com','450323197612311234'),
403 (1016,'111111','陈勉',1,1,'13500000018','上海卢湾区','1986-12-31 00:00:00','test@qq.com','450323198612311251'),
404 (1017,'123456','赵宇航',2,3,'13500000019','北京长安街1号','1981-09-10 00:00:00','test@qq.com','450323198009108311');
405 
406 /*4：Table structure for table `subject`*/
407 
408 DROP TABLE IF EXISTS `subject`;
409 CREATE TABLE `subject`(
410     `SubjectNo` INT(11) NOT NULL AUTO_INCREMENT COMMENT '课程编号',
411     `SubjectName` VARCHAR(50) DEFAULT NULL COMMENT '课程名称',
412     `ClassHour` INT(4) DEFAULT NULL COMMENT '课时',
413     `GradeID` INT(4) DEFAULT NULL COMMENT '年级编号',
414     PRIMARY KEY(`SubjectNo`)
415 )ENGINE=INNODB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
416 
417 
418 /*4：Data for the table `subject`*/
419 INSERT INTO `subject`(`SubjectNo`,`SubjectName`,`ClassHour`,`GradeID`) 
420 VALUES(1,'高等数学-1',110,1),(2,'高等数学-2',110,2),(3,'高等数学-3',110,3),
421 (4,'高等数学-4',130,4),(5,'C语言-1',110,1),(6,'C语言-2',110,2),(7,'C语言-3',110,3),
422 (8,'C语言-4',130,4),(9,'JAVA第一学年',110,1),(10,'JAVA第二学年',110,2),(11,'JAVA第三学年',110,3),
423 (12,'JAVA第四学年',130,4),(13,'数据结构-1',110,1),(14,'数据结构-2',110,2),(15,'数据结构-3',110,3),
424 (16,'数据结构-4',130,4),(17,'C#基础',130,1);

 

posted @ 2020-03-10 18:49  知识改变命运～～～  阅读(118)  评论(0)    收藏  举报