学生数据表

最新推荐文章于 2024-09-11 16:49:52 发布

搬砖的耿小耿

最新推荐文章于 2024-09-11 16:49:52 发布

阅读量2.4k

点赞数 1

分类专栏： mysql 文章标签： mysql 添加学生数据

本文链接：https://blog.csdn.net/weixin_42172054/article/details/80396639

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

USE `students`;
#为科目表添加数据
INSERT INTO `subject`(`subjectNo`,`subjectName`,`classHour`,`gradeID`)
VALUES (1,'Logic Java',220,1),(2,'HTML',160,1),(3,'Java OOP',230,2);
#为学生表添加数据
INSERT INTO `student`(`studentNo`,`loginPwd`,`studentName`,`sex`,`gradeId`,`phone`,`address`,`bornDate`)
VALUES (10000,'123','郭靖',DEFAULT,1,'13645667783','天津市河西区','1990-09-08'),
       (10001,'123','李文才',DEFAULT,1,'13645667890',DEFAULT,'1994-04-12'),
       (10002,'123','李斯文',DEFAULT,1,'13645556793','河南洛阳','1993-07-23'),
       (10003,'123','张萍','女',1,'13642345112',DEFAULT,'1995-06-10'),
       (10004,'123','韩秋洁','女',1,'13812344566','北京市海淀区','1995-07-15'),
       (10005,'123','张秋丽','女',1,'13567893246','北京市东城区','1994-01-17'),
       (10006,'123','肖梅','女',1,'13563456721','河北省石家庄市','1991-02-17'),
       (10007,'123','秦洋',DEFAULT,1,'13056434411','上海市卢湾区','1992-04-18'),
       (10008,'123','何晴晴','女',1,'13053445221','广州市天河区','1997-07-23'),
       (20000,'123','王宝宝',DEFAULT,2,'15076552323',DEFAULT,'1996-06-05'),
       (20010,'123','何晓华','女',2,'13318877954',DEFAULT,'1995-09-10'),
       (30011,'123','陈志强','女',3,'13689965430',DEFAULT,'1994-09-27'),
       (30012,'123','李露露','女',3,'13685678854',DEFAULT,'1992-09-27');
#为成绩表添加数据
INSERT INTO `result`(`studentNo`,`subjectNo`,`examDate`,`studentResult`)
VALUES (10000,1,'2016-02-15 00:00:00',71),
   (10001,1,'2016-02-17 00:00:00',60),
   (10002,1,'2016-02-17 00:00:00',46),
   (10003,1,'2016-02-17 00:00:00',83),
   (10004,1,'2016-02-17 00:00:00',65),
   (10005,1,'2016-02-17 00:00:00',70),
   (10006,1,'2016-02-17 00:00:00',95),
   (10007,1,'2016-02-17 00:00:00',93),
   (10008,1,'2016-02-17 00:00:00',23),
   (20000,3,'2016-07-09 00:00:00',68),
   (20010,3,'2016-07-09 00:00:00',90);