MySQL数据库--记录操作（头歌实操答案）

最新推荐文章于 2024-04-27 11:02:56 发布

fighting@77

最新推荐文章于 2024-04-27 11:02:56 发布

阅读量2.3k

点赞数 2

分类专栏： MySQL 文章标签：数据库 mysql

本文链接：https://blog.csdn.net/qq_74195229/article/details/129916413

版权

MySQL 专栏收录该内容

4 篇文章 3 订阅

订阅专栏

第1关：记录操作

1、MySQL中，insert语句不能完成一次性向表中插入多条记录。
A、对 √  B、错

2、UPDATE语句中若省略了where子句，则修改表中的当前记录。
A、对    B、错 √

3、以下__D____的说法是正确的。
A、在删除表时，如果表之间存在外键约束关系，可以直接删除父表。
B、在删除表时，如果表之间存在外键约束关系，不能直接删除子表。
C、删除子表与父表之间的外键约束后，才可以删除子表。
D、删除子表与父表之间的外键约束后，才可以删除父表。

4、在MySQL中，可以使用以下哪些语句来完成表记录的插入。(BCD)
A、SELECT
B、INSERT…SELECT
C、INSERT
D、REPLACE

第2关：记录操作-插入数据

use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
insert into department values('101',    '信息学院');
insert into department values('102',    '基础部');
insert into department values('201',    '艺术传媒学院');
insert into department values('202',    '管理经济学院'); 
  

insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10101','潘多拉',    '101',    '男',    '计算机',    '副教授');
insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10102','吉米',    '101',    '男',    '计算机',    '讲师');
insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10103','郝本',    '101',    '女',    '计算机',    '副教授');  
insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10201','田野',    '102',    '男',    '数学',        '副教授');
insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10202','赵瑾',    '102',    '女',    '数学',        '讲师');
insert into teacher(teacher_id,teacher_name,department_id,gender,major,professional) values('10203','方圆',    '102',    '女',    '化学',        '副教授');

insert into classes values('1',    '软件工程1班',    1,    '101');
insert into classes values('2',    '软件工程2班',    2,    '101');
insert into classes values('3',    '软件工程3班',    1,    '101');
insert into classes values('4',    '数学',            2,    '102');
insert into classes values('5',    '化学',            3,    '102');
insert into classes values('6',    '广播电视1班',    2,    '201');
insert into classes values('7',    '广播电视2班',    1,    '201');
insert into classes values('8',    '广告学',        3,    '201');
insert into classes values('9',    '会计学',        4,    '202');
insert into classes values('10',    '金融',            4,    '202');

insert into student values('201810101101',    '刘晓东',    '男',    '101',    '1',    '1999-5-10',    '11000000001',    '昆明');
insert into student values('201810101102',    '林慧',        '女',    '101',    '1',    '2000-1-15',    '11000000002',    '上海');    
insert into student values('201810201103',    '李远鹏',    '男',    '102',    '4',    '1999-11-25',    '11000000003',    '北京');    
insert into student values('201810201104',    '吴娜文',    '女',    '102',    '4',    '2000-6-10',    '11000000004',    '昆明');   
insert into student values('201820101105',    '刘智',        '男',    '201',    '8',    '1999-5-8',        '11000000005',    '北京');   
insert into student values('201820101106',    '赵立民',    '男',    '201',    '8',    '2000-2-25',    '11000000006',    '上海');   
insert into student values('201820201111',    '张亮亮',    '男',    '202',    '9',    '1999-11-5',    '11000000007',    '上海');   
insert into student values('201820201116',    '王丽萍',    '女',    '202',    '9',    '1999-6-3',        '11000000008',    '重庆');
insert into course values('1001',    '高等数学',        90,        6,     100,'10201',    '星期一第1-2节','西北B101',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1002',    '化学',            90,        6,     60,    '10202',    '星期二第1-2节','西北B201',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1003',    '计算机基础',    64,        4,     70,    '10101',    '星期一第3-4节','西北B101',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1004',    '数据库应用',    64,        4,     70,    '10101',    '星期二第3-4节','西北B201',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1005',    '会计学',        100,    6,     50,    '10201',    '星期三第1-2节','西北B101',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1006',    '艺术概论',        80,        4,    60,    '10103',    '星期四第3-4节','多媒体202','第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into course values('1007',    '视频制作',        80,        4,    80,    '10102',    '星期二第3-4节','多媒体202','第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '选修');
insert into course values('1008',    '微积分',        90,        6,    100,'10203',    '星期二第3-4节','西北A101',    '第一学期',    '2018-8-15 00:00:00','2018-9-15 00:00:00',    '必修');
insert into choose values(1,    '201810101101',    '1001',    '2018-9-1 00:00:00',    50);
insert into choose values(2,    '201810101101',    '1002',    '2018-9-2 00:00:00',    55); 
insert into choose values(3,    '201810101102',    '1001',    '2018-9-3 00:00:00',    60); 
insert into choose values(4,    '201810101102',    '1002',    '2018-9-1 00:00:00',    65);
insert into choose values(5,    '201810201103',    '1001',    '2018-9-2 00:00:00',    67); 
insert into choose values(6,    '201810201103',    '1004',    '2018-9-2 15:00:00',    70);
insert into choose values(7,    '201810201104',    '1004',    '2018-9-1 00:00:00',    78); 
insert into choose values(8,    '201820101105',    '1005',    '2018-9-2 09:00:00',    82); 
insert into choose values(9,    '201820201111',    '1006',    '2018-9-1 00:00:00',    NULL);
insert into choose values(10,'201820201116',    '1007',    '2018-9-3 00:00:00',    NULL);

 /**********End**********/

第3关：记录操作-插入数据一

use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
  insert into department(department_id,department_name) values("301","生命工程学院");
  REPLACE department(department_id,department_name)values("301","化学工程学院");
 /**********End**********/

第4关：记录操作-插入数据二

use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
  INSERT INTO classes VALUES('20','汉语',2017,'102');
  
 /**********End**********/

第5关：记录操作-插入数据三

 use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
  insert into  student(student_id,student_name,department_id,class_id) values("202111019101","Joe","101","1");
  SELECT * FROM student;
  
  
 /**********End**********/

第6关：记录操作-插入数据四

use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
  create table classes1 select * from classes where department_id='101';
 /**********End**********/

第7关：记录操作-插入数据五

  use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
 insert into choose(id,student_id,course_id,choose_time,score)values("11","201911111111","1004","2019-12-25 00:00:00","85");
 SELECT * FROM choose;
 /**********End**********/

第8关：记录操作-更新数据

use course;
 /****请在此编写代码，操作完毕之后点击评测******/
 
 /**********Begin**********/
   update classes
set class_name="大数据"
where class_id="1";
 /**********End**********/

第9关：记录操作-更新操作一

  use course;

CREATE TABLE choose1 LIKE choose;
INSERT INTO choose1 SELECT * FROM choose;
CREATE TABLE choose2 LIKE choose;
INSERT INTO choose2 SELECT * FROM choose;

/***使用delete语句删除choose1表中内容****/
/***************Begin********************/
 delete from choose1;

/***************end********************/



/***使用TRUNCATE语句删除choose2表中内容****/
/***************Begin********************/

truncate table choose2;
/***************end********************/
select * from choose;  
select * from choose1;  
select * from choose2;

第10关：记录操作-更新操作二

use course;    
/*************begin****************/
insert into department  values ("101","西南联大");
insert into classes values("1","软件工程1班","1","101");
insert into student values("201810101101","冯友兰","男","101","1","1895-12-04","11000000001","河南省南阳市唐河县祁仪镇人");
insert into student values("201810101102","朱自清","男","101","1","1898-11-22","11000000002",	"江苏省东海县");
insert into student values('201810201103','闻一多','男','101','1','1899-11-24','11000000003','湖北浠水县巴河镇');
insert into student values("201810201104",	"林徽因","女","101","1","1904-6-10","11000000004","浙江杭州");
insert into student values("201820101105",	"梁思成","男","101","1","1901-4-20"	,"11000000005",	"广东新会");
/*************end***************/
select * from student;