第71卷 数据库的基本查询《MySQL数据库基础》湖北省技能高考《计算机类考纲百套卷》

编写说明：湖北省技能高考《计算机类考纲百套卷》,依据《湖北省普通高等学校招收中等职业学校毕业生技能高考计算机类技能考试大纲》编写。每门课程均分三层训练：基础层(具象化支架)以拆解考点为微目标,紧扣考纲 掌握理解 要求编写考点训练卷；巩固层(关联性支架)强化知识交叉与场景关联,按考纲专题编专题训练卷；应用层(引导性支架)聚焦真题突破,结合知识模块与教材编写课程综合卷。 本试卷是第71卷,按《MySQL数据库基础》范围和要求编写。具体内容为:掌握SQL查询的基本概念,熟练掌握简单查询、统计函数查询、条件查询的操作方法 湖北省《计算机类考纲百套卷》 第71卷 《MySQL数据库基础》 数据库的基本查询 考点训练卷 考试时间80分钟 满分100分 班级 姓名 学号 成绩 素材 一、数据库操作题(本大题共10小题,每题10分,共100分) 1.社交网络数据库db_social包含了t_user用户表、t_friendship好友关系表、t_post动态表、点赞表 t_user包含字段uid(用户编号),username(用户名),password(密码),nickname(昵称),age(年龄),sex(性别)。 t_friendship包含字段 fsid(好友关系编号),uid(用户id),fid(好友id),createtime(添加时间)。 t_post包含字段pid(动态编号),uid(用户编号),content(内容),createtime(创建时间) t_likes包含字段lid(点赞编号),pid(动态编号),fid(好友id),createtime(点赞时间)。 (1).查询所有年龄大于等于18岁的男性用户的用户名和昵称。 (2).查询昵称中包含小字的所有用户信息。 (3).统计每位用户发布的动态数量,显示用户编号和动态条数。 (4).查询2025年6月1日当天发布的全部动态,显示发布用户昵称、动态内容和发布时间。 (5).统计每条动态的点赞数量,显示动态编号、动态内容和点赞数,按点赞数降序排列。 (6).查询从未发布过任何动态的用户编号和用户名 2.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段sid(学生编号),sname(学生姓名),username(用户名),password(密码),classes(班级)。 t_course包含字段 cid(课程编号),cname(课程名称),description(描述), classhour(课时)。 t_video包括字段vid(视频编号),cid(课程编号),title(标题),link(链接地址) t_Learn学习记录表lid(学习记录编号),sid(学生编号),cid(课程编号),schedule(学习进度),createtime(创建时间)。 (1).查询所有班级为计算机科学与技术1班的学生姓名和用户名。 (2).查询课时数大于等于32的所有课程的名称和课时数。 (3).统计每门课程拥有的视频数量,显示课程名称和视频数量。 (4).查询学习进度大于80%的学习记录,显示学生姓名、课程名称和学习进度。 (5).统计每位学生的学习课程门数,显示学生姓名和学习课程数量。 (6).查询2025年5月份的所有学习记录,显示学生姓名、课程名称和创建时间 3.学生成绩系统数据库db_grade包含了t_student学生表t_grade成绩表和t_course科目表 t_student包含字段sid(学生编号),sname(姓名),sex(性别),class(班级)。 t_course包含字段 cid(科目编号),cname(科目名称),total(总分)。 t_grade包含字段gid(成绩编号),sid(学生编号),cid(科目编号),score(分数)。 (1).查询所有女生的姓名和班级。 (2).查询成绩在60分到80分之间的所有成绩记录,显示学生姓名、科目名称和分数。 (3).统计每位学生的总分,显示学生姓名和总分,按总分降序排列。 (4).查询每门科目的平均分,显示科目名称和平均分(保留两位小数)。 (5).查询张三同学的所有科目成绩,显示科目名称和分数。 (6).查询缺考(未登记成绩)的学生姓名和学号 4.医疗管理数据库db_treatment包含了t_patient患者表、t_doctor医生表、t_registration挂号表 t_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 t_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 t_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 (1).查询所有年龄大于60岁的男性患者的姓名和联系电话。 (2).查询职称为主治医师的医生姓名和科室。 (3).统计每位医生的接诊人数,显示医生姓名和接诊人数,按接诊人数降序排列。 (4).查询2025年6月份的所有挂号记录,显示患者姓名、医生姓名和挂号日期。 (5).统计内科(office=内科)医生的人数。 (6)查询从未挂过号的患者姓名和联系电话 5.舞蹈课程管理系统数据库db_dance包含了t_student学员表、t_course课程表 、t_class班级表和t_teacher老师表。 t_student包含字段id(学生编号),name(学生姓名),sex(性别),age(年龄),tel(联系方式),cls_id(班级编号); t_course包含字段id(课程编号),name(课程名称),period(课时) t_class包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式); (1).查询所有年龄在18至25岁之间的女性学员姓名和联系电话。 (2).查询课时数大于20的所有课程名称和课时数。 (3).统计每位老师所带班级的数量,显示老师姓名和班级数量。 (4).查询拉丁舞课程的所有班级上课时间。 (5).统计每个班级的学员人数,显示班级名称和学员人数。 (6).查询所有未分配班级的学员姓名和年龄 6.医疗管理数据库db_treatment包含了tb_patient患者表、tb_doctor医生表和tb_registration挂号表 tb_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 tb_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 tb_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 (1).查询所有联系电话以139开头的患者姓名。 (2).查询2025年5月1日至2025年5月31日期间的所有挂号记录。 (3).统计每位患者的挂号次数,显示患者姓名和挂号次数。 (4).查询副主任医师及以上职称(副主任医师、主任医师)的医生姓名和科室。 (5).查询所有未挂过号的患者姓名和年龄。 (6).统计各科室的挂号总人次,显示科室名称和挂号人次 7.舞蹈课程管理系统数据库db_dance包含了t_student学员表、t_course课程表 、t_class班级表和t_teacher老师表。 t_student包含字段id(学生编号),name(学生姓名),sex(性别),age(年龄),tel(联系方式),cls_id(班级编号); t_course包含字段id(课程编号),name(课程名称),period(课时) t_class包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式),salary(薪资); (1).查询所有年龄小于等于15岁的男性学员姓名和年龄。 (2).查询薪资在5000至10000元之间的女老师姓名和薪资。 (3).统计每种课程的总课时数,显示课程名称和总课时。 (4).查询周一上课的所有班级名称和上课时间。 (5).统计每个班级的学员人数,显示班级名称和学员人数 (6).查询学员人数最多的班级名称和人数 8.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段id(学生编号),name(学生姓名),username(用户名),password(密码)。 t_course包含字段 id(课程编号),name(课程名称),description(描述),period(课时)。 t_video包括字段id(视频编号),c_id(课程编号),title(标题),link(链接地址) t_learn学习记录表id(学习记录编号),s_id(学生编号),c_id(课程编号),schedule(学习进度),createtime(创建时间)。 (1).查询用户名以admin开头的所有学生姓名。 (2).查询描述中包含入门二字的课程名称和描述。 (3).统计每门课程的学习记录总数,显示课程名称和学习人数。 (4).查询学习进度为100%(已完成)的学习记录,显示学生姓名、课程名称。 (5).统计每位学生的平均学习进度,显示学生姓名和平均进度(保留一位小数)。 (6).查询2025年1月1日之后有学习记录的所有学生姓名 9.人力资源管理系统数据库db_hrm包含了t_employee员工表、t_department部门表和t_salary薪资表 t_employee包含字段id(员工编号),name(员工姓名),sex(性别),age(年龄),position(职位),d_id(部门编号)。 t_department包含字段 id(部门编号),name(部门名称),description(部门描述)。 t_salary包含字段id(薪资编号),e_id(员工编号),money(薪资),time(薪资日期) (1).查询所有技术部员工的姓名、职位和年龄。 (2).查询年龄在30至40岁之间的女性员工的姓名和职位。 (3).统计各部门的员工人数,显示部门名称和员工人数。 (4).查询2025年6月份所有薪资记录,显示员工姓名、薪资额和薪资日期。 (5).统计每位员工的平均薪资,显示员工姓名和平均薪资(保留两位小数)。 (6).查询薪资高于8000元的员工姓名、职位和薪资额 10.人力资源管理系统数据库db_hrm包含了t_employee员工表、t_department部门表和t_salary薪资表 t_employee包含字段id(员工编号),name(员工姓名),sex(性别),age(年龄),position(职位),d_id(部门编号)。 t_department包含字段 id(部门编号),name(部门名称),description(部门描述)。 t_salary包含字段id(薪资编号),e_id(员工编号),money(薪资),time(薪资日期) (1).查询所有年龄大于45岁的男性员工的姓名和职位。 (2).查询职位为经理或总监的员工姓名和所在部门名称。 (3).统计2025年各月份的薪资发放总额,显示月份和总额。 (4).查询产品部所有员工的姓名和年龄,按年龄降序排列。 (5).统计各部门的平均薪资,显示部门名称和平均薪资(保留两位小数)。 (6).查询薪资最高和最低的员工姓名及薪资额 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 第10题/db_hrm.myd CREATE DATABASE IF NOT EXISTS `db_hrm` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `db_hrm`; /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_hrm Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 05/06/2024 11:32:36 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_department -- ---------------------------- DROP TABLE IF EXISTS `t_department`; CREATE TABLE `t_department` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10007 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_department -- ---------------------------- INSERT INTO `t_department` VALUES (10001, '财务部', '财务部是指在本机构一定的整体目标下，关于资产的购置（投资），资本的融通（筹资）和经营中现金流量（营运资金），以及利润分配的管理的部门。'); INSERT INTO `t_department` VALUES (10002, '行政部', '行政部门是组织或企业中负责管理和支持日常行政事务的部门。'); INSERT INTO `t_department` VALUES (10003, '销售部', '销售部门是组织内负责销售和市场推广活动的部门。其主要职责是促进产品或服务的销售，实现组织的销售目标和利润增长。销售部门通常与市场部门密切协作，共同制定销售策略和营销计划。'); INSERT INTO `t_department` VALUES (10004, '技术部', '技术部门是一个组织内负责技术开发、技术支持和技术管理的部门。其主要职责是提供技术解决方案，支持组织的技术需求，并确保技术的有效运作和发展。'); INSERT INTO `t_department` VALUES (10005, '后勤部', '后勤部是为其它各部门职能能够顺利实现提供物质服务的一个部门'); -- ---------------------------- -- Table structure for t_employee -- ---------------------------- DROP TABLE IF EXISTS `t_employee`; CREATE TABLE `t_employee` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(5) NULL DEFAULT NULL, `position` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `d_id` int(10) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10052 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_employee -- ---------------------------- INSERT INTO `t_employee` VALUES (10001, '曹岚', '女', 25, '正式员工', 10003); INSERT INTO `t_employee` VALUES (10002, '丁子韬', '男', 34, '正式员工', 10004); INSERT INTO `t_employee` VALUES (10003, '陈睿', '男', 40, '高级员工', 10005); INSERT INTO `t_employee` VALUES (10004, '彭宇宁', '男', 28, '经理', 10003); INSERT INTO `t_employee` VALUES (10005, '孟宇宁', '男', 34, '高级员工', 10005); INSERT INTO `t_employee` VALUES (10006, '郭嘉伦', '男', 27, '高级员工', 10004); INSERT INTO `t_employee` VALUES (10007, '顾子异', '男', 32, '高级员工', 10003); INSERT INTO `t_employee` VALUES (10008, '孔岚', '女', 27, '经理', 10005); INSERT INTO `t_employee` VALUES (10009, '曹宇宁', '男', 29, '高级员工', 10002); INSERT INTO `t_employee` VALUES (10010, '向云熙', '男', 34, '高级员工', 10001); INSERT INTO `t_employee` VALUES (10011, '陈致远', '男', 25, '经理', 10001); INSERT INTO `t_employee` VALUES (10012, '武璐', '女', 34, '正式员工', 10003); INSERT INTO `t_employee` VALUES (10013, '郝晓明', '男', 31, '实习生', 10005); INSERT INTO `t_employee` VALUES (10014, '韩晓明', '男', 30, '实习生', 10003); INSERT INTO `t_employee` VALUES (10015, '戴安琪', '女', 24, '实习生', 10002); INSERT INTO `t_employee` VALUES (10016, '徐宇宁', '男', 35, '经理', 10002); INSERT INTO `t_employee` VALUES (10017, '魏安琪', '女', 40, '实习生', 10004); INSERT INTO `t_employee` VALUES (10018, '余安琪', '女', 36, '高级员工', 10002); INSERT INTO `t_employee` VALUES (10019, '向璐', '女', 29, '经理', 10004); INSERT INTO `t_employee` VALUES (10020, '崔致远', '男', 35, '高级员工', 10002); INSERT INTO `t_employee` VALUES (10021, '任宇宁', '男', 29, '实习生', 10005); INSERT INTO `t_employee` VALUES (10022, '叶睿', '男', 36, '高级员工', 10004); INSERT INTO `t_employee` VALUES (10023, '邓宇宁', '男', 35, '实习生', 10004); INSERT INTO `t_employee` VALUES (10024, '阎秀英', '女', 34, '高级员工', 10001); INSERT INTO `t_employee` VALUES (10025, '孟致远', '男', 34, '实习生', 10001); INSERT INTO `t_employee` VALUES (10026, '雷睿', '男', 39, '实习生', 10004); INSERT INTO `t_employee` VALUES (10027, '罗璐', '女', 27, '正式员工', 10002); INSERT INTO `t_employee` VALUES (10028, '蔡睿', '男', 30, '实习生', 10001); INSERT INTO `t_employee` VALUES (10029, '袁岚', '女', 34, '实习生', 10002); INSERT INTO `t_employee` VALUES (10030, '江宇宁', '男', 29, '高级员工', 10001); INSERT INTO `t_employee` VALUES (10031, '董安琪', '女', 31, '正式员工', 10002); INSERT INTO `t_employee` VALUES (10032, '阎嘉伦', '男', 24, '正式员工', 10005); INSERT INTO `t_employee` VALUES (10033, '魏致远', '男', 27, '正式员工', 10002); INSERT INTO `t_employee` VALUES (10034, '于嘉伦', '男', 23, '实习生', 10002); INSERT INTO `t_employee` VALUES (10035, '韩宇宁', '男', 25, '正式员工', 10002); INSERT INTO `t_employee` VALUES (10036, '宋杰宏', '男', 34, '高级员工', 10003); INSERT INTO `t_employee` VALUES (10037, '汪璐', '女', 31, '实习生', 10001); INSERT INTO `t_employee` VALUES (10038, '韩子异', '男', 31, '正式员工', 10003); INSERT INTO `t_employee` VALUES (10039, '高睿', '男', 31, '正式员工', 10002); INSERT INTO `t_employee` VALUES (10040, '钱宇宁', '男', 28, '实习生', 10005); INSERT INTO `t_employee` VALUES (10041, '钟子韬', '男', 29, '高级员工', 10001); INSERT INTO `t_employee` VALUES (10042, '萧子韬', '男', 34, '正式员工', 10005); INSERT INTO `t_employee` VALUES (10043, '吴云熙', '男', 30, '高级员工', 10005); INSERT INTO `t_employee` VALUES (10044, '苏震南', '男', 37, '高级员工', 10001); INSERT INTO `t_employee` VALUES (10045, '黄岚', '女', 26, '正式员工', 10003); INSERT INTO `t_employee` VALUES (10046, '赵宇宁', '男', 33, '高级员工', 10005); INSERT INTO `t_employee` VALUES (10047, '许嘉伦', '男', 29, '实习生', 10002); INSERT INTO `t_employee` VALUES (10048, '孔睿', '男', 37, '高级员工', 10004); INSERT INTO `t_employee` VALUES (10049, '陈云熙', '男', 25, '正式员工', 10001); INSERT INTO `t_employee` VALUES (10050, '金宇宁', '男', 28, '正式员工', 10005); -- ---------------------------- -- Records of t_purchase -- ---------------------------- -- ---------------------------- -- Table structure for t_salary -- ---------------------------- DROP TABLE IF EXISTS `t_salary`; CREATE TABLE `t_salary` ( `id` int(10) NOT NULL AUTO_INCREMENT, `e_id` int(10) NULL DEFAULT NULL, `money` decimal(10, 2) NULL DEFAULT NULL, `time` date NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_salary -- ---------------------------- INSERT INTO `t_salary` VALUES (10001, 10046, 6433.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10002, 10041, 9790.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10003, 10040, 8464.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10004, 10028, 7018.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10005, 10013, 5402.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10006, 10022, 6368.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10007, 10024, 7404.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10008, 10042, 5401.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10009, 10007, 6049.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10010, 10048, 5281.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10011, 10033, 7063.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10012, 10035, 8835.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10013, 10026, 7035.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10014, 10012, 9922.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10015, 10039, 6497.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10016, 10017, 5886.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10017, 10032, 5266.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10018, 10034, 6711.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10019, 10050, 7245.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10020, 10049, 9272.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10021, 10003, 5735.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10022, 10014, 5654.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10023, 10025, 6875.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10024, 10021, 7578.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10025, 10011, 5949.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10026, 10020, 6050.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10027, 10027, 9881.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10028, 10037, 5912.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10029, 10005, 6696.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10030, 10002, 9584.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10031, 10043, 6744.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10032, 10006, 7471.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10033, 10031, 9545.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10034, 10029, 5758.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10035, 10038, 9656.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10036, 10019, 8875.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10037, 10009, 9506.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10038, 10018, 7310.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10039, 10047, 9341.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10040, 10001, 10000.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10041, 10015, 7182.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10042, 10023, 7322.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10043, 10008, 8605.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10044, 10001, 8406.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10045, 10030, 6779.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10046, 10045, 7257.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10047, 10036, 8226.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10048, 10044, 6933.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10049, 10016, 9858.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10050, 10004, 5995.00, '2023-12-15'); INSERT INTO `t_salary` VALUES (10051, 10035, 6439.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10052, 10027, 9253.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10053, 10038, 9502.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10054, 10016, 5817.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10055, 10013, 9357.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10056, 10040, 7632.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10057, 10050, 8117.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10058, 10014, 6203.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10059, 10002, 6592.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10060, 10045, 5942.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10061, 10003, 6926.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10062, 10015, 9381.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10063, 10049, 5525.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10064, 10048, 7493.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10065, 10021, 6205.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10066, 10042, 9429.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10067, 10018, 6815.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10068, 10024, 8044.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10069, 10020, 6381.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10070, 10006, 6020.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10071, 10044, 9105.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10072, 10036, 7961.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10073, 10047, 9417.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10074, 10031, 9481.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10075, 10032, 8984.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10076, 10019, 9756.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10077, 10025, 7597.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10078, 10010, 7616.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10079, 10008, 6574.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10080, 10046, 9142.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10081, 10041, 5881.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10082, 10001, 5874.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10083, 10005, 8222.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10084, 10009, 6899.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10085, 10029, 6606.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10086, 10017, 5412.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10087, 10023, 9739.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10088, 10028, 8329.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10089, 10033, 7426.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10090, 10012, 7572.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10091, 10034, 7821.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10092, 10026, 9401.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10093, 10022, 8226.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10094, 10030, 8020.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10095, 10011, 8723.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10096, 10039, 8327.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10097, 10004, 7497.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10098, 10043, 5230.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10099, 10007, 9206.00, '2023-11-15'); INSERT INTO `t_salary` VALUES (10100, 10037, 7612.00, '2023-11-15'); 第1题/db_social.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_social Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 04/12/2023 15:10:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_friendship -- ---------------------------- DROP TABLE IF EXISTS `t_friendship`; CREATE TABLE `t_friendship` ( `fsid` int(10) NOT NULL AUTO_INCREMENT `uid` int(10) NULL DEFAULT NULL `fid` int(10) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`fsid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_friendship -- ---------------------------- INSERT INTO `t_friendship` VALUES (10001 10003 10009 '2002-04-04 01:50:50'); INSERT INTO `t_friendship` VALUES (10002 10012 10005 '2001-05-20 04:00:06'); INSERT INTO `t_friendship` VALUES (10003 10009 10004 '2010-12-19 01:07:49'); INSERT INTO `t_friendship` VALUES (10004 10008 10001 '2010-02-10 10:30:30'); INSERT INTO `t_friendship` VALUES (10005 10011 10013 '2014-03-30 01:38:33'); INSERT INTO `t_friendship` VALUES (10006 10001 10020 '2007-10-08 17:28:48'); INSERT INTO `t_friendship` VALUES (10007 10019 10009 '2007-12-06 23:26:42'); INSERT INTO `t_friendship` VALUES (10008 10010 10016 '2005-03-21 12:18:51'); INSERT INTO `t_friendship` VALUES (10009 10007 10017 '2016-06-15 04:52:59'); INSERT INTO `t_friendship` VALUES (10010 10014 10004 '2007-10-26 09:36:32'); INSERT INTO `t_friendship` VALUES (10011 10018 10011 '2019-04-05 20:55:26'); INSERT INTO `t_friendship` VALUES (10012 10020 10003 '2017-03-25 13:46:34'); INSERT INTO `t_friendship` VALUES (10013 10006 10006 '2019-12-08 01:28:33'); INSERT INTO `t_friendship` VALUES (10014 10005 10014 '2000-01-30 13:45:26'); INSERT INTO `t_friendship` VALUES (10015 10017 10012 '2010-07-06 23:56:41'); INSERT INTO `t_friendship` VALUES (10016 10002 10001 '2003-11-18 02:35:48'); INSERT INTO `t_friendship` VALUES (10017 10013 10003 '2004-09-26 06:30:19'); INSERT INTO `t_friendship` VALUES (10018 10016 10013 '2016-05-06 21:42:34'); INSERT INTO `t_friendship` VALUES (10019 10004 10018 '2016-07-22 16:42:12'); INSERT INTO `t_friendship` VALUES (10020 10015 10002 '2008-08-13 11:52:14'); INSERT INTO `t_friendship` VALUES (10021 10019 10010 '2019-10-19 05:15:00'); INSERT INTO `t_friendship` VALUES (10022 10019 10017 '2015-05-17 23:29:15'); INSERT INTO `t_friendship` VALUES (10023 10018 10013 '2002-02-04 14:25:32'); INSERT INTO `t_friendship` VALUES (10024 10002 10014 '2003-05-29 06:46:36'); INSERT INTO `t_friendship` VALUES (10025 10002 10001 '2012-09-05 06:09:52'); INSERT INTO `t_friendship` VALUES (10026 10015 10016 '2019-09-21 07:11:07'); INSERT INTO `t_friendship` VALUES (10027 10010 10006 '2001-08-04 13:09:40'); INSERT INTO `t_friendship` VALUES (10028 10008 10002 '2000-05-03 01:46:48'); INSERT INTO `t_friendship` VALUES (10029 10011 10010 '2023-05-13 10:03:10'); INSERT INTO `t_friendship` VALUES (10030 10015 10010 '2023-09-18 12:05:18'); INSERT INTO `t_friendship` VALUES (10031 10003 10010 '2023-10-14 10:58:49'); INSERT INTO `t_friendship` VALUES (10032 10017 10020 '2014-01-03 07:56:10'); INSERT INTO `t_friendship` VALUES (10033 10013 10008 '2002-06-10 13:18:22'); INSERT INTO `t_friendship` VALUES (10034 10012 10011 '2004-04-26 00:18:56'); INSERT INTO `t_friendship` VALUES (10035 10017 10016 '2015-02-03 02:01:15'); INSERT INTO `t_friendship` VALUES (10036 10009 10006 '2014-04-09 05:30:28'); INSERT INTO `t_friendship` VALUES (10037 10005 10004 '2013-02-10 07:48:18'); INSERT INTO `t_friendship` VALUES (10038 10013 10020 '2022-03-03 18:35:47'); INSERT INTO `t_friendship` VALUES (10039 10020 10010 '2021-01-11 01:13:43'); INSERT INTO `t_friendship` VALUES (10040 10009 10010 '2015-11-24 22:22:40'); INSERT INTO `t_friendship` VALUES (10041 10004 10013 '2000-06-27 13:32:43'); INSERT INTO `t_friendship` VALUES (10042 10011 10002 '2020-02-01 05:44:39'); INSERT INTO `t_friendship` VALUES (10043 10018 10006 '2011-01-01 09:56:26'); INSERT INTO `t_friendship` VALUES (10044 10005 10014 '2015-02-26 02:27:57'); INSERT INTO `t_friendship` VALUES (10045 10008 10004 '2011-06-30 04:45:03'); INSERT INTO `t_friendship` VALUES (10046 10010 10013 '2013-08-22 02:37:54'); INSERT INTO `t_friendship` VALUES (10047 10001 10003 '2006-08-28 16:12:09'); INSERT INTO `t_friendship` VALUES (10048 10016 10011 '2022-03-22 03:48:39'); INSERT INTO `t_friendship` VALUES (10049 10014 10012 '2022-05-09 05:44:28'); INSERT INTO `t_friendship` VALUES (10050 10006 10002 '2020-01-06 03:24:32'); -- ---------------------------- -- Table structure for t_likes -- ---------------------------- DROP TABLE IF EXISTS `t_likes`; CREATE TABLE `t_likes` ( `lid` int(10) NOT NULL AUTO_INCREMENT `pid` int(11) NULL DEFAULT NULL `fid` int(11) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_likes -- ---------------------------- INSERT INTO `t_likes` VALUES (10001 10032 10017 '2001-10-04 21:44:01'); INSERT INTO `t_likes` VALUES (10002 10023 10001 '2022-02-18 08:37:36'); INSERT INTO `t_likes` VALUES (10003 10009 10016 '2003-07-23 17:16:43'); INSERT INTO `t_likes` VALUES (10004 10008 10013 '2008-06-02 00:36:15'); INSERT INTO `t_likes` VALUES (10005 10011 10008 '2023-11-20 20:30:02'); INSERT INTO `t_likes` VALUES (10006 10041 10003 '2003-08-09 18:06:15'); INSERT INTO `t_likes` VALUES (10007 10026 10012 '2015-08-14 16:05:12'); INSERT INTO `t_likes` VALUES (10008 10044 10002 '2012-02-17 16:58:03'); INSERT INTO `t_likes` VALUES (10009 10038 10004 '2008-07-25 03:46:02'); INSERT INTO `t_likes` VALUES (10010 10015 10005 '2004-03-03 04:12:39'); INSERT INTO `t_likes` VALUES (10011 10047 10014 '2005-08-03 16:55:45'); INSERT INTO `t_likes` VALUES (10012 10007 10009 '2013-10-27 14:55:15'); INSERT INTO `t_likes` VALUES (10013 10027 10007 '2010-03-09 15:35:03'); INSERT INTO `t_likes` VALUES (10014 10025 10019 '2015-02-11 10:27:53'); INSERT INTO `t_likes` VALUES (10015 10022 10018 '2010-07-18 18:07:15'); INSERT INTO `t_likes` VALUES (10016 10018 10006 '2014-05-15 22:12:11'); INSERT INTO `t_likes` VALUES (10017 10045 10015 '2005-11-04 15:59:38'); INSERT INTO `t_likes` VALUES (10018 10033 10011 '2005-12-22 05:47:18'); INSERT INTO `t_likes` VALUES (10019 10001 10010 '2015-10-08 04:53:15'); INSERT INTO `t_likes` VALUES (10020 10017 10020 '2009-05-13 13:46:05'); INSERT INTO `t_likes` VALUES (10021 10019 10008 '2002-06-26 21:34:07'); INSERT INTO `t_likes` VALUES (10022 10016 10002 '2005-06-29 14:02:06'); INSERT INTO `t_likes` VALUES (10023 10003 10017 '2003-12-22 10:50:10'); INSERT INTO `t_likes` VALUES (10024 10021 10011 '2019-07-14 18:23:10'); INSERT INTO `t_likes` VALUES (10025 10034 10018 '2019-11-28 02:18:34'); INSERT INTO `t_likes` VALUES (10026 10006 10013 '2003-04-08 16:16:39'); INSERT INTO `t_likes` VALUES (10027 10048 10009 '2023-01-06 06:36:19'); INSERT INTO `t_likes` VALUES (10028 10042 10013 '2013-07-13 11:11:06'); INSERT INTO `t_likes` VALUES (10029 10036 10002 '2015-04-30 14:41:42'); INSERT INTO `t_likes` VALUES (10030 10002 10007 '2012-02-29 09:33:42'); INSERT INTO `t_likes` VALUES (10031 10037 10019 '2007-07-31 03:46:45'); INSERT INTO `t_likes` VALUES (10032 10029 10008 '2003-10-27 16:27:50'); INSERT INTO `t_likes` VALUES (10033 10012 10014 '2009-01-26 02:43:55'); INSERT INTO `t_likes` VALUES (10034 10030 10018 '2016-07-12 13:31:24'); INSERT INTO `t_likes` VALUES (10035 10035 10017 '2000-01-25 02:43:04'); INSERT INTO `t_likes` VALUES (10036 10028 10019 '2019-01-04 21:35:33'); INSERT INTO `t_likes` VALUES (10037 10031 10008 '2006-04-21 08:35:30'); INSERT INTO `t_likes` VALUES (10038 10049 10017 '2000-07-26 06:08:06'); INSERT INTO `t_likes` VALUES (10039 10004 10009 '2023-09-05 15:22:10'); INSERT INTO `t_likes` VALUES (10040 10043 10001 '2015-03-26 15:54:46'); INSERT INTO `t_likes` VALUES (10041 10005 10014 '2015-05-21 02:43:43'); INSERT INTO `t_likes` VALUES (10042 10046 10013 '2018-04-28 11:35:59'); INSERT INTO `t_likes` VALUES (10043 10024 10020 '2020-12-30 04:43:22'); INSERT INTO `t_likes` VALUES (10044 10050 10006 '2015-12-27 07:07:00'); INSERT INTO `t_likes` VALUES (10045 10014 10002 '2001-07-12 09:10:50'); INSERT INTO `t_likes` VALUES (10046 10040 10001 '2013-08-12 19:47:56'); INSERT INTO `t_likes` VALUES (10047 10039 10003 '2003-04-08 16:00:47'); INSERT INTO `t_likes` VALUES (10048 10013 10010 '2009-02-21 01:51:41'); INSERT INTO `t_likes` VALUES (10049 10010 10017 '2009-06-22 17:34:07'); INSERT INTO `t_likes` VALUES (10050 10020 10004 '2019-10-24 00:30:07'); INSERT INTO `t_likes` VALUES (10051 10037 10009 '2017-01-26 15:41:20'); INSERT INTO `t_likes` VALUES (10052 10019 10010 '2004-03-05 07:49:17'); INSERT INTO `t_likes` VALUES (10053 10024 10007 '2003-08-12 01:06:49'); INSERT INTO `t_likes` VALUES (10054 10018 10015 '2009-11-15 17:25:31'); INSERT INTO `t_likes` VALUES (10055 10011 10019 '2008-08-31 14:41:22'); INSERT INTO `t_likes` VALUES (10056 10027 10004 '2021-07-30 12:50:58'); INSERT INTO `t_likes` VALUES (10057 10040 10012 '2009-06-18 03:32:59'); INSERT INTO `t_likes` VALUES (10058 10041 10011 '2005-07-15 08:40:49'); INSERT INTO `t_likes` VALUES (10059 10027 10001 '2023-11-03 00:16:59'); INSERT INTO `t_likes` VALUES (10060 10017 10003 '2022-01-09 05:57:27'); INSERT INTO `t_likes` VALUES (10061 10025 10005 '2003-02-11 00:42:46'); INSERT INTO `t_likes` VALUES (10062 10021 10004 '2016-07-31 05:26:24'); INSERT INTO `t_likes` VALUES (10063 10036 10012 '2005-02-21 01:16:20'); INSERT INTO `t_likes` VALUES (10064 10017 10019 '2023-01-30 23:58:39'); INSERT INTO `t_likes` VALUES (10065 10026 10013 '2022-08-03 04:41:12'); INSERT INTO `t_likes` VALUES (10066 10007 10014 '2004-02-06 13:25:20'); INSERT INTO `t_likes` VALUES (10067 10007 10018 '2023-10-29 12:47:27'); INSERT INTO `t_likes` VALUES (10068 10039 10020 '2016-09-27 15:00:18'); INSERT INTO `t_likes` VALUES (10069 10046 10015 '2015-05-06 03:39:44'); INSERT INTO `t_likes` VALUES (10070 10002 10007 '2016-02-05 05:48:52'); INSERT INTO `t_likes` VALUES (10071 10047 10002 '2015-03-18 13:22:58'); INSERT INTO `t_likes` VALUES (10072 10021 10011 '2002-12-21 21:16:38'); INSERT INTO `t_likes` VALUES (10073 10040 10017 '2018-01-28 02:31:12'); INSERT INTO `t_likes` VALUES (10074 10050 10008 '2022-12-27 15:45:29'); INSERT INTO `t_likes` VALUES (10075 10005 10010 '2010-10-12 06:34:09'); INSERT INTO `t_likes` VALUES (10076 10050 10002 '2021-08-21 22:27:44'); INSERT INTO `t_likes` VALUES (10077 10044 10017 '2004-04-07 10:52:28'); INSERT INTO `t_likes` VALUES (10078 10030 10015 '2013-07-11 19:36:53'); INSERT INTO `t_likes` VALUES (10079 10010 10008 '2018-09-07 11:29:25'); INSERT INTO `t_likes` VALUES (10080 10014 10006 '2002-01-31 00:05:49'); INSERT INTO `t_likes` VALUES (10081 10011 10010 '2021-10-19 00:55:37'); INSERT INTO `t_likes` VALUES (10082 10018 10016 '2000-03-10 09:20:16'); INSERT INTO `t_likes` VALUES (10083 10012 10007 '2009-03-22 19:06:25'); INSERT INTO `t_likes` VALUES (10084 10006 10009 '2016-09-18 14:11:18'); INSERT INTO `t_likes` VALUES (10085 10008 10012 '2010-11-20 08:14:55'); INSERT INTO `t_likes` VALUES (10086 10043 10004 '2008-02-27 12:30:05'); INSERT INTO `t_likes` VALUES (10087 10030 10003 '2000-03-29 07:18:02'); INSERT INTO `t_likes` VALUES (10088 10026 10018 '2016-02-23 23:15:54'); INSERT INTO `t_likes` VALUES (10089 10048 10017 '2006-10-05 01:59:59'); INSERT INTO `t_likes` VALUES (10090 10044 10008 '2020-09-09 00:03:47'); INSERT INTO `t_likes` VALUES (10091 10008 10018 '2020-08-29 18:22:05'); INSERT INTO `t_likes` VALUES (10092 10009 10012 '2019-10-31 01:59:48'); INSERT INTO `t_likes` VALUES (10093 10025 10013 '2011-03-16 13:02:56'); INSERT INTO `t_likes` VALUES (10094 10043 10006 '2023-10-22 19:31:52'); INSERT INTO `t_likes` VALUES (10095 10001 10020 '2011-07-23 22:21:20'); INSERT INTO `t_likes` VALUES (10096 10034 10008 '2006-11-08 11:59:44'); INSERT INTO `t_likes` VALUES (10097 10024 10003 '2021-04-06 01:14:15'); INSERT INTO `t_likes` VALUES (10098 10039 10014 '2019-06-16 04:55:10'); INSERT INTO `t_likes` VALUES (10099 10032 10001 '2007-11-02 19:19:16'); INSERT INTO `t_likes` VALUES (10100 10029 10020 '2014-02-04 05:11:29'); -- ---------------------------- -- Table structure for t_post -- ---------------------------- DROP TABLE IF EXISTS `t_post`; CREATE TABLE `t_post` ( `pid` int(10) NOT NULL AUTO_INCREMENT `uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `createtime` date NULL DEFAULT NULL PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_post -- ---------------------------- INSERT INTO `t_post` VALUES (10001 '10003' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab.' '2020-10-04'); INSERT INTO `t_post` VALUES (10002 '10006' 'You will succeed because most people are lazy. Creativity is intelligence having fun. The Main Window consists of several toolbars and panes for you to work on connections database objects and advanced tools.' '2014-07-10'); INSERT INTO `t_post` VALUES (10003 '10011' 'Flexible settings enable you to set up a custom key for comparison and synchronization. The first step is as good as half over. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port ' '2007-06-05'); INSERT INTO `t_post` VALUES (10004 '10002' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information. SSH serves to prevent such vulnerabilities ' '2000-03-20'); INSERT INTO `t_post` VALUES (10005 '10019' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed ' '2021-05-19'); INSERT INTO `t_post` VALUES (10006 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2013-07-27'); INSERT INTO `t_post` VALUES (10007 '10012' 'You must be the change you wish to see in the world. Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords ' '2016-05-17'); INSERT INTO `t_post` VALUES (10008 '10010' 'It is used while your ISPs do not allow direct connections but allows establishing HTTP connections. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Instead of wondering when your next vacation ' '2013-06-26'); INSERT INTO `t_post` VALUES (10009 '10017' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2014-03-09'); INSERT INTO `t_post` VALUES (10010 '10018' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Cloud provides a cloud service for synchronizing connections queries model files and virtual group information ' '2017-08-24'); INSERT INTO `t_post` VALUES (10011 '10008' 'Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. If you wait all that happens is you get older.' '2013-01-01'); INSERT INTO `t_post` VALUES (10012 '10007' 'You cannot save people you can just love them. Typically it is employed as an encrypted version of Telnet. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up ' '2015-12-09'); INSERT INTO `t_post` VALUES (10013 '10001' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If your Internet Service Provider (ISP) does not provide direct access to its server Secure ' '2007-04-07'); INSERT INTO `t_post` VALUES (10014 '10020' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Champions keep playing until they get it right. Navicat 15 has added support for the system-wide dark mode.' '2012-01-31'); INSERT INTO `t_post` VALUES (10015 '10014' 'A man’s best friends are his ten fingers. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. What you get by achieving your goals is not as ' '2015-01-04'); INSERT INTO `t_post` VALUES (10016 '10015' 'Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or MongoDB databases making database administration to multiple kinds of database so easy.' '2013-08-24'); INSERT INTO `t_post` VALUES (10017 '10016' 'Actually it is just in an idea when feel oneself can achieve and cannot achieve. A man is not old until regrets take the place of dreams.' '2008-07-11'); INSERT INTO `t_post` VALUES (10018 '10013' 'The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles and preview.' '2006-12-28'); INSERT INTO `t_post` VALUES (10019 '10004' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2013-07-30'); INSERT INTO `t_post` VALUES (10020 '10005' 'HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. A man is not old until regrets take the place of dreams.' '2023-09-01'); INSERT INTO `t_post` VALUES (10021 '10007' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. There is no way to happiness. Happiness is the way. The reason why a great man is great is that he resolves to be a great man.' '2018-01-18'); INSERT INTO `t_post` VALUES (10022 '10006' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration.' '2001-11-07'); INSERT INTO `t_post` VALUES (10023 '10019' 'Genius is an infinite capacity for taking pains. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2022-04-06'); INSERT INTO `t_post` VALUES (10024 '10012' 'If your Internet Service Provider (ISP) does not provide direct access to its server Secure Tunneling Protocol (SSH) / HTTP is another solution. What you get by achieving your goals is not as important as what you become by achieving your goals.' '2002-07-07'); INSERT INTO `t_post` VALUES (10025 '10014' 'If you wait all that happens is you get older. With its well-designed Graphical User Interface(GUI) Navicat lets you quickly and easily create organize access and share information in a secure and easy way.' '2004-06-25'); INSERT INTO `t_post` VALUES (10026 '10004' 'To clear or reload various internal caches flush tables or acquire locks control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature.' '2004-05-09'); INSERT INTO `t_post` VALUES (10027 '10005' 'I may not have gone where I intended to go but I think I have ended up where I needed to be. A comfort zone is a beautiful place but nothing ever grows there.' '2003-08-15'); INSERT INTO `t_post` VALUES (10028 '10006' 'Champions keep playing until they get it right. Remember that failure is an event not a person. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual logical and physical data models.' '2016-10-28'); INSERT INTO `t_post` VALUES (10029 '10010' 'What you get by achieving your goals is not as important as what you become by achieving your goals. After logged in the Navicat Cloud feature the Navigation pane will be divided into Navicat Cloud and My Connections sections.' '2021-10-29'); INSERT INTO `t_post` VALUES (10030 '10014' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If the Show objects under schema in navigation pane option is checked at the Preferences ' '2007-03-17'); INSERT INTO `t_post` VALUES (10031 '10001' 'If it scares you it might be a good thing to try. I destroy my enemies when I make them my friends. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does.' '2005-12-06'); INSERT INTO `t_post` VALUES (10032 '10019' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Monitor requires a repository to store alerts and metrics for historical analysis.' '2014-12-11'); INSERT INTO `t_post` VALUES (10033 '10018' 'Creativity is intelligence having fun. I destroy my enemies when I make them my friends. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or ' '2017-03-22'); INSERT INTO `t_post` VALUES (10034 '10012' 'To connect to a database or schema simply double-click it in the pane. Flexible settings enable you to set up a custom key for comparison and synchronization. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2022-11-13'); INSERT INTO `t_post` VALUES (10035 '10017' 'If the Show objects under schema in navigation pane option is checked at the Preferences window all database objects are also displayed in the pane. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. ' '2012-02-23'); INSERT INTO `t_post` VALUES (10036 '10008' 'Optimism is the one quality more associated with success and happiness than any other. A query is used to extract data from the database in a readable format according to the user\'s request.' '2005-12-16'); INSERT INTO `t_post` VALUES (10037 '10002' 'The past has no power over the present moment. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored.' '2016-04-13'); INSERT INTO `t_post` VALUES (10038 '10010' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. It collects process metrics such as CPU load RAM usage and a variety of other resources over SSH/SNMP.' '2010-10-20'); INSERT INTO `t_post` VALUES (10039 '10003' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network.' '2019-07-20'); INSERT INTO `t_post` VALUES (10040 '10020' 'Optimism is the one quality more associated with success and happiness than any other. In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session ' '2003-11-25'); INSERT INTO `t_post` VALUES (10041 '10007' 'Creativity is intelligence having fun. A comfort zone is a beautiful place but nothing ever grows there. After comparing data the window shows the number of records that will be inserted updated or deleted in the target.' '2003-03-21'); INSERT INTO `t_post` VALUES (10042 '10001' 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Genius is an infinite capacity for taking pains. Anyone who has ever made anything of importance was disciplined.' '2000-03-30'); INSERT INTO `t_post` VALUES (10043 '10002' 'Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet.' '2013-12-21'); INSERT INTO `t_post` VALUES (10044 '10016' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information.' '2016-03-25'); INSERT INTO `t_post` VALUES (10045 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2004-03-05'); INSERT INTO `t_post` VALUES (10046 '10017' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network. How we spend our days is of course how we spend our lives. I may not have gone ' '2015-07-06'); INSERT INTO `t_post` VALUES (10047 '10013' 'Navicat Monitor requires a repository to store alerts and metrics for historical analysis. The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles ' '2016-09-13'); INSERT INTO `t_post` VALUES (10048 '10016' 'Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2005-01-10'); INSERT INTO `t_post` VALUES (10049 '10020' 'You cannot save people you can just love them. The On Startup feature allows you to control what tabs appear when you launch Navicat. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2010-05-16'); INSERT INTO `t_post` VALUES (10050 '10015' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2004-04-21'); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `uid` int(10) NOT NULL AUTO_INCREMENT `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `age` int(3) NULL DEFAULT NULL `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL PRIMARY KEY (`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (10001 'RcZMBygzEP' 'KAc0k5N7ik' 'Kimberly' 31 '女'); INSERT INTO `t_user` VALUES (10002 'xZbFVNFPfC' 'YGQPYvApoW' 'Betty' 19 '女'); INSERT INTO `t_user` VALUES (10003 'rWQkglfDHp' 'a090zWktf2' 'Barry' 43 'ç”·'); INSERT INTO `t_user` VALUES (10004 'AsWnNuQrBn' 'AzS6Fiv4TD' 'Randy' 49 'ç”·'); INSERT INTO `t_user` VALUES (10005 'ydPZCqwaWz' 'SwOjHxNc29' 'Amy' 30 '女'); INSERT INTO `t_user` VALUES (10006 'egikGPKoHB' '0IyNHa4ACw' 'Ruth' 33 '女'); INSERT INTO `t_user` VALUES (10007 'AWxdiAksDt' 'j6vFisZKc1' 'April' 38 '女'); INSERT INTO `t_user` VALUES (10008 'aUTVurILei' 'bPxFeeKhy8' 'Cynthia' 38 '女'); INSERT INTO `t_user` VALUES (10009 'RcOgLMMata' 'AxhUsVUU78' 'Tammy' 20 '女'); INSERT INTO `t_user` VALUES (10010 'iRnxECjbol' 'QCfHAiimrG' 'Alice' 15 '女'); INSERT INTO `t_user` VALUES (10011 'FhqYITqTdA' 'dVNCEepBKC' 'Thelma' 46 '女'); INSERT INTO `t_user` VALUES (10012 'hBFObiRjOn' 'qoKKRgbYzO' 'Bradley' 27 'ç”·'); INSERT INTO `t_user` VALUES (10013 'nOLwlDpyIN' 'tGuW0T5FcG' 'Jean' 28 '女'); INSERT INTO `t_user` VALUES (10014 'VYhKLehGcy' 'phKBleXEQ9' 'Jose' 44 'ç”·'); INSERT INTO `t_user` VALUES (10015 'ybKBizSikJ' 'l7sRDLObVU' 'Daniel' 48 'ç”·'); INSERT INTO `t_user` VALUES (10016 'uvOZOdSvbV' 'eYmVqLJm3z' 'Rosa' 22 '女'); INSERT INTO `t_user` VALUES (10017 'OHZBeflocp' '8O8DZeCB9R' 'Tony' 44 'ç”·'); INSERT INTO `t_user` VALUES (10018 'gHfroIcoQc' '63USEuGBeB' 'Thomas' 16 'ç”·'); INSERT INTO `t_user` VALUES (10019 'HRQGdchgoS' 'apvalUkIbQ' 'Kelly' 17 '女'); INSERT INTO `t_user` VALUES (10020 'tBFVIvbDgj' 'IwcjzMg9xB' 'Steven' 33 'ç”·'); SET FOREIGN_KEY_CHECKS = 1; 第2题/db_education.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_education Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 05/12/2023 09:42:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(10) NULL DEFAULT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classhour` int(10) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '语文', '高中语文课程', 24); INSERT INTO `t_course` VALUES (10002, '数学', '高中数学课程', 24); INSERT INTO `t_course` VALUES (10003, '英语', '高中英语课程', 24); -- ---------------------------- -- Table structure for t_learn -- ---------------------------- DROP TABLE IF EXISTS `t_learn`; CREATE TABLE `t_learn` ( `lid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `schedule` int(10) NULL DEFAULT 0, `createtime` date NULL DEFAULT NULL, PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_learn -- ---------------------------- INSERT INTO `t_learn` VALUES ('10001', '10026', '10003', 8, '2001-08-21'); INSERT INTO `t_learn` VALUES ('10002', '10044', '10001', 7, '2001-01-30'); INSERT INTO `t_learn` VALUES ('10003', '10024', '10003', 15, '2011-11-02'); INSERT INTO `t_learn` VALUES ('10004', '10029', '10003', 15, '2019-08-20'); INSERT INTO `t_learn` VALUES ('10005', '10042', '10003', 19, '2005-09-13'); INSERT INTO `t_learn` VALUES ('10006', '10033', '10004', 7, '2006-09-05'); INSERT INTO `t_learn` VALUES ('10007', '10043', '10004', 16, '2015-01-16'); INSERT INTO `t_learn` VALUES ('10008', '10037', '10002', 18, '2008-06-16'); INSERT INTO `t_learn` VALUES ('10009', '10010', '10003', 4, '2011-02-08'); INSERT INTO `t_learn` VALUES ('10010', '10034', '10004', 22, '2001-03-18'); INSERT INTO `t_learn` VALUES ('10011', '10021', '10003', 3, '2005-04-02'); INSERT INTO `t_learn` VALUES ('10012', '10036', '10001', 18, '2019-02-23'); INSERT INTO `t_learn` VALUES ('10013', '10002', '10003', 10, '2002-06-14'); INSERT INTO `t_learn` VALUES ('10014', '10030', '10003', 7, '2023-11-04'); INSERT INTO `t_learn` VALUES ('10015', '10011', '10002', 1, '2002-12-28'); INSERT INTO `t_learn` VALUES ('10016', '10035', '10004', 13, '2003-05-17'); INSERT INTO `t_learn` VALUES ('10017', '10014', '10003', 9, '2017-09-01'); INSERT INTO `t_learn` VALUES ('10018', '10015', '10001', 11, '2001-05-26'); INSERT INTO `t_learn` VALUES ('10019', '10012', '10003', 8, '2009-04-21'); INSERT INTO `t_learn` VALUES ('10020', '10017', '10003', 4, '2018-08-24'); INSERT INTO `t_learn` VALUES ('10021', '10003', '10003', 5, '2019-07-31'); INSERT INTO `t_learn` VALUES ('10022', '10038', '10003', 23, '2011-12-29'); INSERT INTO `t_learn` VALUES ('10023', '10032', '10003', 14, '2003-08-19'); INSERT INTO `t_learn` VALUES ('10024', '10039', '10003', 12, '2004-02-06'); INSERT INTO `t_learn` VALUES ('10025', '10041', '10001', 21, '2002-07-12'); INSERT INTO `t_learn` VALUES ('10026', '10006', '10001', 13, '2013-10-15'); INSERT INTO `t_learn` VALUES ('10027', '10020', '10001', 16, '2020-06-08'); INSERT INTO `t_learn` VALUES ('10028', '10008', '10001', 13, '2023-11-18'); INSERT INTO `t_learn` VALUES ('10029', '10007', '10003', 10, '2000-12-21'); INSERT INTO `t_learn` VALUES ('10030', '10049', '10004', 3, '2021-12-24'); INSERT INTO `t_learn` VALUES ('10031', '10047', '10004', 7, '2005-04-17'); INSERT INTO `t_learn` VALUES ('10032', '10023', '10002', 16, '2002-09-10'); INSERT INTO `t_learn` VALUES ('10033', '10019', '10002', 7, '2021-03-27'); INSERT INTO `t_learn` VALUES ('10034', '10001', '10003', 5, '2010-10-03'); INSERT INTO `t_learn` VALUES ('10035', '10028', '10004', 11, '2008-05-06'); INSERT INTO `t_learn` VALUES ('10036', '10016', '10002', 24, '2009-05-27'); INSERT INTO `t_learn` VALUES ('10037', '10009', '10002', 2, '2021-05-03'); INSERT INTO `t_learn` VALUES ('10038', '10027', '10004', 11, '2022-10-06'); INSERT INTO `t_learn` VALUES ('10039', '10040', '10003', 8, '2023-03-01'); INSERT INTO `t_learn` VALUES ('10040', '10031', '10003', 5, '2017-04-23'); INSERT INTO `t_learn` VALUES ('10041', '10050', '10004', 0, '2017-04-16'); INSERT INTO `t_learn` VALUES ('10042', '10025', '10002', 14, '2020-11-18'); INSERT INTO `t_learn` VALUES ('10043', '10048', '10003', 3, '2000-02-01'); INSERT INTO `t_learn` VALUES ('10044', '10005', '10001', 2, '2000-07-30'); INSERT INTO `t_learn` VALUES ('10045', '10046', '10001', 6, '2009-01-21'); INSERT INTO `t_learn` VALUES ('10046', '10004', '10001', 14, '2011-05-07'); INSERT INTO `t_learn` VALUES ('10047', '10022', '10003', 14, '2007-09-05'); INSERT INTO `t_learn` VALUES ('10048', '10013', '10003', 20, '2002-04-02'); INSERT INTO `t_learn` VALUES ('10049', '10018', '10004', 10, '2010-05-19'); INSERT INTO `t_learn` VALUES ('10050', '10045', '10003', 10, '2015-10-31'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(10) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `classes` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '贾子韬', 'rqkpnrpw', 'qGhyfhyGio', '高一1班'); INSERT INTO `t_student` VALUES (10002, '曾詩涵', 'wllbpxpf', 'Ft8qo5iwJ0', '高三2班'); INSERT INTO `t_student` VALUES (10003, '高睿', 'gzairzdb', 'C1L1N4OBX4', '高二2班'); INSERT INTO `t_student` VALUES (10004, '孔璐', 'plgtkjxy', '4ARIJvsdI7', '高三1班'); INSERT INTO `t_student` VALUES (10005, '邱璐', 'dkhtjxob', 'aa9NUeo9sF', '高一1班'); INSERT INTO `t_student` VALUES (10006, '林晓明', 'lbtkgcep', 'q7GaI78tY3', '高三1班'); INSERT INTO `t_student` VALUES (10007, '廖子异', 'heumgwpi', '9iCA9pCACl', '高二2班'); INSERT INTO `t_student` VALUES (10008, '吴宇宁', 'immknini', 'hnlwlWXfMw', '高二2班'); INSERT INTO `t_student` VALUES (10009, '陶致远', 'vaaibzte', 'zSyRZSbTll', '高三2班'); INSERT INTO `t_student` VALUES (10010, '田致远', 'hvmqiebm', 'Fvm4G9VhkZ', '高二2班'); INSERT INTO `t_student` VALUES (10011, '任震南', 'bkqoxgrp', 'ZM5Cw5utTm', '高一2班'); INSERT INTO `t_student` VALUES (10012, '雷岚', 'mhrviqys', '9aVltYbPHE', '高一2班'); INSERT INTO `t_student` VALUES (10013, '傅子韬', 'yxvpgzui', '0sPq0v3IeJ', '高一2班'); INSERT INTO `t_student` VALUES (10014, '韦杰宏', 'bqifzjrt', '9Oo6J5odqP', '高二1班'); INSERT INTO `t_student` VALUES (10015, '马子异', 'zzhjqmrz', 'a1gMAwnLs2', '高三2班'); INSERT INTO `t_student` VALUES (10016, '莫秀英', 'bxktahbz', 'IWCVNvMGL6', '高一2班'); INSERT INTO `t_student` VALUES (10017, '常宇宁', 'xdbqtnqs', 'w8Dn5mTtGp', '高一2班'); INSERT INTO `t_student` VALUES (10018, '朱子异', 'qjstcwjc', 'Zr2mtrMpVE', '高三1班'); INSERT INTO `t_student` VALUES (10019, '方震南', 'syfrtkyu', '2AoUfr5ZnK', '高一1班'); INSERT INTO `t_student` VALUES (10020, '沈宇宁', 'ictjevir', '5F24FmvV1q', '高二2班'); INSERT INTO `t_student` VALUES (10021, '吕安琪', 'caquymom', 'EAQjHmn8z7', '高一2班'); INSERT INTO `t_student` VALUES (10022, '宋璐', 'dpbgvoqx', 'TT3IPCOX5B', '高一1班'); INSERT INTO `t_student` VALUES (10023, '潘秀英', 'bqxhwqdf', 'DNGok5w6CC', '高三1班'); INSERT INTO `t_student` VALUES (10024, '莫詩涵', 'ktmtgcrs', 'OKkp6v553e', '高三1班'); INSERT INTO `t_student` VALUES (10025, '熊璐', 'txfpxsis', 'T54gy0Hb3S', '高三2班'); INSERT INTO `t_student` VALUES (10026, '潘震南', 'ihrjenzb', 'w2R8wdbUug', '高三2班'); INSERT INTO `t_student` VALUES (10027, '陈詩涵', 'qehknger', 'fPp0m6qm4A', '高一2班'); INSERT INTO `t_student` VALUES (10028, '严杰宏', 'swhwmmbn', 'UJpPxYXcfG', '高一1班'); INSERT INTO `t_student` VALUES (10029, '韩璐', 'rgwoyxfj', 'fpRrn8hP7k', '高一1班'); INSERT INTO `t_student` VALUES (10030, '汪詩涵', 'qeiwzawn', 'mdDK734hYf', '高二1班'); INSERT INTO `t_student` VALUES (10031, '尹子异', 'iojbrdtg', '0o3Ymue1Ts', '高一1班'); INSERT INTO `t_student` VALUES (10032, '贾秀英', 'pjrbxcgi', 'wvQ7ul5Ygl', '高二2班'); INSERT INTO `t_student` VALUES (10033, '吕震南', 'oedjepmq', 'EpkZMcblN4', '高三2班'); INSERT INTO `t_student` VALUES (10034, '金杰宏', 'zedxgqur', 'upz5cfstS8', '高二2班'); INSERT INTO `t_student` VALUES (10035, '汪震南', 'azlhdsgv', 'UEjf4k3J4Y', '高一1班'); INSERT INTO `t_student` VALUES (10036, '邹秀英', 'ezcuzosf', 'AVDfHqPSBA', '高一1班'); INSERT INTO `t_student` VALUES (10037, '韦子韬', 'thghwrxm', 'hOPYmq90aI', '高三2班'); INSERT INTO `t_student` VALUES (10038, '邓岚', 'xibjqcqr', 'KHVLMHEdB2', '高二1班'); INSERT INTO `t_student` VALUES (10039, '侯晓明', 'wqsboqtx', '1JlWkJhuin', '高二1班'); INSERT INTO `t_student` VALUES (10040, '方睿', 'rigthudo', 'iOolu1XLWk', '高三2班'); INSERT INTO `t_student` VALUES (10041, '丁宇宁', 'xajjnxdn', '2OPHE1Xwdt', '高二1班'); INSERT INTO `t_student` VALUES (10042, '胡嘉伦', 'njybwilz', 'T4FyjyQ06G', '高二2班'); INSERT INTO `t_student` VALUES (10043, '孟岚', 'nvkvehrp', 'JkSNXREhIK', '高三2班'); INSERT INTO `t_student` VALUES (10044, '孟云熙', 'kkkpqfgs', 'PmdSsBaIVE', '高三2班'); INSERT INTO `t_student` VALUES (10045, '曹宇宁', 'falyiyal', 'LZruWY2x3D', '高二1班'); INSERT INTO `t_student` VALUES (10046, '陶睿', 'qyatgwvv', 'reKaYJZup4', '高三2班'); INSERT INTO `t_student` VALUES (10047, '程嘉伦', 'ytehfenv', 'xK2tx3HDDg', '高二1班'); INSERT INTO `t_student` VALUES (10048, '贺子韬', 'fwloybvz', '8qdM7vBgi6', '高三2班'); INSERT INTO `t_student` VALUES (10049, '石安琪', 'dcjajfyv', 'TT2kI3uUNK', '高三2班'); INSERT INTO `t_student` VALUES (10050, '贺岚', 'vqxzrdft', 'XE4wrXCITj', '高三2班'); -- ---------------------------- -- Table structure for t_video -- ---------------------------- DROP TABLE IF EXISTS `t_video`; CREATE TABLE `t_video` ( `vid` int(10) NOT NULL AUTO_INCREMENT, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`vid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10073 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_video -- ---------------------------- INSERT INTO `t_video` VALUES (10001, '10002', 'To successfully establish a new ', 'https://video.misgo.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10002, '10003', 'It is used while your ISPs do not ', 'http://video.fancm.us/ToysGames'); INSERT INTO `t_video` VALUES (10003, '10003', 'In other words, Navicat provides ', 'http://video.harada75.cn/Beauty'); INSERT INTO `t_video` VALUES (10004, '10002', 'It collects process metrics such ', 'http://video.kuliksun.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10005, '10003', 'Creativity is intelligence having fun.', 'https://video.waisanyam87.com/VideoGames'); INSERT INTO `t_video` VALUES (10006, '10002', 'Such sessions are also susceptible ', 'http://video.chin44.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10007, '10001', 'What you get by achieving your ', 'http://video.tanganqi.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10008, '10002', 'I will greet this day with love in my heart.', 'https://video.yinyunx.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10009, '10002', 'HTTP Tunneling is a method for ', 'http://video.fatl803.com/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10010, '10001', 'The first step is as good as half over. ', 'https://video.wuzhenn.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10011, '10003', 'To connect to a database or schema, ', 'http://video.lu15.xyz/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10012, '10001', 'The past has no power over the present moment.', 'http://video.burnsheather.info/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10013, '10001', 'It is used while your ISPs do not ', 'http://video.nts.com/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10014, '10001', 'The reason why a great man is great ', 'http://video.cheng1.xyz/Appliances'); INSERT INTO `t_video` VALUES (10015, '10003', 'The Main Window consists of several ', 'https://video.monicacraw5.info/HealthBabyCare'); INSERT INTO `t_video` VALUES (10016, '10001', 'The first step is as good as half over.', 'https://video.kinoshitahikaru1988.jp/Appliances'); INSERT INTO `t_video` VALUES (10017, '10002', 'In the Objects tab, you can use ', 'http://video.anoguchi.com/Others'); INSERT INTO `t_video` VALUES (10018, '10001', 'To start working with your server ', 'https://video.hicksjulie.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10019, '10003', 'The past has no power over the present moment.', 'https://video.sklo.org/FilmSupplies'); INSERT INTO `t_video` VALUES (10020, '10003', 'The On Startup feature allows you ', 'http://video.jijiang47.net/HealthBabyCare'); INSERT INTO `t_video` VALUES (10021, '10001', 'Navicat provides a wide range advanced ', 'http://video.linzita.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10022, '10002', 'The Information Pane shows the ', 'https://video.barnfr4.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10023, '10002', 'If it scares you, it might be a good thing to try.', 'https://video.shi704.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10024, '10001', 'Navicat Data Modeler is a powerful ', 'https://video.xu2015.xyz/VideoGames'); INSERT INTO `t_video` VALUES (10025, '10002', 'There is no way to happiness. Happiness ', 'http://video.suy.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10026, '10002', 'I will greet this day with love in my heart.', 'http://video.tang420.org/Baby'); INSERT INTO `t_video` VALUES (10027, '10003', 'In the middle of winter I at last ', 'https://video.xiy6.xyz/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10028, '10003', 'The Main Window consists of several ', 'https://video.jr59.jp/ComputersElectronics'); INSERT INTO `t_video` VALUES (10029, '10001', 'A query is used to extract data ', 'http://video.sakuroka1109.net/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10030, '10003', 'All journeys have secret destinations ', 'http://video.mmiyamoto.xyz/Appliances'); INSERT INTO `t_video` VALUES (10031, '10003', 'Navicat Monitor can be installed ', 'https://video.gard.com/CDsVinyl'); INSERT INTO `t_video` VALUES (10032, '10002', 'What you get by achieving your ', 'http://video.jefferywhi9.jp/AppsGames'); INSERT INTO `t_video` VALUES (10033, '10001', 'Navicat provides a wide range advanced ', 'http://video.ziyx2010.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10034, '10001', 'Optimism is the one quality more ', 'http://video.lxiu1.co.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10035, '10003', 'The On Startup feature allows you ', 'https://video.carmenhug.info/Baby'); INSERT INTO `t_video` VALUES (10036, '10002', 'The past has no power over the present moment.', 'http://video.cyuning.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10037, '10002', 'A man is not old until regrets ', 'http://video.yunxi84.co.jp/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10038, '10003', 'Secure Sockets Layer(SSL) is a ', 'http://video.jiechan.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10039, '10002', 'The Main Window consists of several ', 'https://video.randyspe.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10040, '10003', 'Navicat Monitor requires a repository ', 'https://video.kwokkn10.info/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10041, '10001', 'If the Show objects under schema ', 'https://video.okfan.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10042, '10003', 'To successfully establish a new ', 'https://video.liziyi.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10043, '10003', 'SQL Editor allows you to create ', 'http://video.kcharles.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10044, '10002', 'A man is not old until regrets ', 'http://video.sseiko.com/VideoGames'); INSERT INTO `t_video` VALUES (10045, '10001', 'If opportunity doesn’t knock, build a door.', 'http://video.ngkm.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10046, '10002', 'To successfully establish a new ', 'https://video.lsze.biz/MusicalInstrument'); INSERT INTO `t_video` VALUES (10047, '10002', 'I may not have gone where I intended ', 'http://video.whwu9.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10048, '10001', 'You will succeed because most people are lazy.', 'https://video.bh4.us/PetSupplies'); INSERT INTO `t_video` VALUES (10049, '10003', 'Actually it is just in an idea ', 'https://video.duanxia104.net/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10050, '10003', 'The reason why a great man is great ', 'https://video.zhennanwe.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10051, '10002', 'Navicat Monitor can be installed ', 'http://video.xiaoziyi.cn/Beauty'); INSERT INTO `t_video` VALUES (10052, '10003', 'I destroy my enemies when I make them my friends.', 'https://video.melissa506.us/Appliances'); INSERT INTO `t_video` VALUES (10053, '10003', 'I may not have gone where I intended ', 'http://video.colemb.co.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10054, '10001', 'Navicat provides powerful tools ', 'https://video.xiaomingli.com/Books'); INSERT INTO `t_video` VALUES (10055, '10002', 'Navicat Cloud provides a cloud ', 'http://video.cooperjuan803.biz/Appliances'); INSERT INTO `t_video` VALUES (10056, '10001', 'If your Internet Service Provider ', 'http://video.hiutung1025.co.jp/Food'); INSERT INTO `t_video` VALUES (10057, '10002', 'You can select any connections, ', 'http://video.kolu.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10058, '10003', 'SSH serves to prevent such vulnerabilities ', 'http://video.taniguchi727.com/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10059, '10003', 'There is no way to happiness. Happiness ', 'https://video.takedaminat67.net/AppsGames'); INSERT INTO `t_video` VALUES (10060, '10003', 'A query is used to extract data ', 'http://video.yunintang.jp/MusicalInstrument'); INSERT INTO `t_video` VALUES (10061, '10003', 'The Synchronize to Database function ', 'https://video.llu.biz/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10062, '10001', 'To open a query using an external ', 'http://video.yuen6.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10063, '10002', 'If the Show objects under schema ', 'http://video.huimeicho.biz/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10064, '10001', 'I destroy my enemies when I make them my friends.', 'http://video.yuitomori.cn/Beauty'); INSERT INTO `t_video` VALUES (10065, '10001', 'It provides strong authentication ', 'http://video.kondo1.biz/Others'); INSERT INTO `t_video` VALUES (10066, '10001', 'Typically, it is employed as an ', 'http://video.nantanaka10.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10067, '10001', 'Navicat Monitor can be installed ', 'http://video.konaoshi1.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10068, '10002', 'The past has no power over the present moment. ', 'http://video.yoshida205.cn/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10069, '10001', 'It provides strong authentication ', 'https://video.chiuwaiwan2.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10070, '10002', 'Typically, it is employed as an ', 'https://video.kwch.xyz/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10071, '10001', 'There is no way to happiness. Happiness ', 'https://video.daniels74.com/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10072, '10002', 'To connect to a database or schema, ', 'https://video.tinwingmak.co.jp/BaggageTravelEquipment'); SET FOREIGN_KEY_CHECKS = 1; 第3题/db_grade.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_grade Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 23/11/2023 15:31:23 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(11) NOT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `total` int(5) NULL DEFAULT NULL, PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '英语', 150); INSERT INTO `t_course` VALUES (10002, '语文', 150); INSERT INTO `t_course` VALUES (10003, '数学', 150); -- ---------------------------- -- Table structure for t_grade -- ---------------------------- DROP TABLE IF EXISTS `t_grade`; CREATE TABLE `t_grade` ( `gid` int(10) NOT NULL, `sid` int(10) NOT NULL, `cid` int(10) NOT NULL, `score` int(10) NULL DEFAULT NULL, PRIMARY KEY (`gid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_grade -- ---------------------------- INSERT INTO `t_grade` VALUES (10001, 10010, 10003, 53); INSERT INTO `t_grade` VALUES (10002, 10001, 10002, 52); INSERT INTO `t_grade` VALUES (10003, 10007, 10003, 53); INSERT INTO `t_grade` VALUES (10004, 10001, 10001, 124); INSERT INTO `t_grade` VALUES (10005, 10003, 10003, 119); INSERT INTO `t_grade` VALUES (10006, 10003, 10002, 145); INSERT INTO `t_grade` VALUES (10007, 10008, 10002, 109); INSERT INTO `t_grade` VALUES (10008, 10006, 10002, 101); INSERT INTO `t_grade` VALUES (10009, 10003, 10001, 128); INSERT INTO `t_grade` VALUES (10010, 10002, 10001, 110); INSERT INTO `t_grade` VALUES (10011, 10002, 10003, 146); INSERT INTO `t_grade` VALUES (10012, 10007, 10001, 132); INSERT INTO `t_grade` VALUES (10013, 10010, 10001, 126); INSERT INTO `t_grade` VALUES (10014, 10010, 10002, 104); INSERT INTO `t_grade` VALUES (10015, 10006, 10001, 109); INSERT INTO `t_grade` VALUES (10016, 10001, 10003, 99); INSERT INTO `t_grade` VALUES (10017, 10002, 10002, 138); INSERT INTO `t_grade` VALUES (10018, 10006, 10003, 105); INSERT INTO `t_grade` VALUES (10019, 10008, 10001, 141); INSERT INTO `t_grade` VALUES (10020, 10005, 10002, 90); INSERT INTO `t_grade` VALUES (10021, 10004, 10003, 54); INSERT INTO `t_grade` VALUES (10022, 10005, 10003, 86); INSERT INTO `t_grade` VALUES (10023, 10009, 10001, 138); INSERT INTO `t_grade` VALUES (10024, 10005, 10001, 126); INSERT INTO `t_grade` VALUES (10025, 10007, 10002, 111); INSERT INTO `t_grade` VALUES (10026, 10009, 10003, 120); INSERT INTO `t_grade` VALUES (10027, 10004, 10002, 103); INSERT INTO `t_grade` VALUES (10028, 10009, 10002, 125); INSERT INTO `t_grade` VALUES (10029, 10004, 10001, 87); INSERT INTO `t_grade` VALUES (10030, 10008, 10003, 51); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(11) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '夏震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10002, '孔璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10003, '田璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10004, '田秀英', '女', '高二3班'); INSERT INTO `t_student` VALUES (10005, '宋詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10006, '薛詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10007, '石震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10008, '梁致远', '男', '高二3班'); INSERT INTO `t_student` VALUES (10009, '顾璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10010, '魏晓明', '男', '高二3班'); SET FOREIGN_KEY_CHECKS = 1; 第4题/db_treatment.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_treatment Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 05/12/2023 10:57:18 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_doctor -- ---------------------------- DROP TABLE IF EXISTS `t_doctor`; CREATE TABLE `t_doctor` ( `did` int(10) NOT NULL AUTO_INCREMENT, `dname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `office` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`did`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_doctor -- ---------------------------- INSERT INTO `t_doctor` VALUES (10001, '孟睿', '外科', '实习医生', '196-1142-8607'); INSERT INTO `t_doctor` VALUES (10002, '孙云熙', '耳鼻喉科', '实习医生', '133-0211-7241'); INSERT INTO `t_doctor` VALUES (10003, '邹岚', '内科', '高级医生', '10-560-1386'); INSERT INTO `t_doctor` VALUES (10004, '周子异', '外科', '实习医生', '199-8805-8963'); INSERT INTO `t_doctor` VALUES (10005, '朱睿', '外科', '中级医生', '191-5127-0466'); INSERT INTO `t_doctor` VALUES (10006, '常安琪', '耳鼻喉科', '实习医生', '755-780-8243'); INSERT INTO `t_doctor` VALUES (10007, '崔秀英', '儿科', '主任', '186-1296-4216'); INSERT INTO `t_doctor` VALUES (10008, '董詩涵', '外科', '主任', '760-5492-7849'); INSERT INTO `t_doctor` VALUES (10009, '崔秀英', '内科', '中级医生', '10-1750-7240'); INSERT INTO `t_doctor` VALUES (10010, '周睿', '耳鼻喉科', '高级医生', '755-834-7691'); INSERT INTO `t_doctor` VALUES (10011, '卢震南', '儿科', '中级医生', '186-5900-0614'); INSERT INTO `t_doctor` VALUES (10012, '雷震南', '耳鼻喉科', '高级医生', '178-6511-9350'); INSERT INTO `t_doctor` VALUES (10013, '雷岚', '儿科', '实习医生', '190-6306-4361'); INSERT INTO `t_doctor` VALUES (10014, '唐云熙', '内科', '中级医生', '755-0855-7704'); INSERT INTO `t_doctor` VALUES (10015, '郑震南', '儿科', '中级医生', '20-8721-5863'); INSERT INTO `t_doctor` VALUES (10016, '贾杰宏', '内科', '主任', '130-1162-3953'); INSERT INTO `t_doctor` VALUES (10017, '任睿', '耳鼻喉科', '主任', '21-4613-2793'); INSERT INTO `t_doctor` VALUES (10018, '侯安琪', '内科', '中级医生', '769-867-7575'); INSERT INTO `t_doctor` VALUES (10019, '郝杰宏', '儿科', '实习医生', '21-638-0661'); INSERT INTO `t_doctor` VALUES (10020, '秦晓明', '内科', '中级医生', '178-0882-6094'); -- ---------------------------- -- Table structure for t_patient -- ---------------------------- DROP TABLE IF EXISTS `t_patient`; CREATE TABLE `t_patient` ( `pid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(5) NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_patient -- ---------------------------- INSERT INTO `t_patient` VALUES ('10001', '严子韬', '男', 30, '178-8729-5799'); INSERT INTO `t_patient` VALUES ('10002', '蔡詩涵', '女', 17, '755-6590-9717'); INSERT INTO `t_patient` VALUES ('10003', '蔡嘉伦', '男', 31, '147-0244-7071'); INSERT INTO `t_patient` VALUES ('10004', '卢安琪', '女', 19, '28-018-1654'); INSERT INTO `t_patient` VALUES ('10005', '许宇宁', '男', 57, '139-8471-7072'); INSERT INTO `t_patient` VALUES ('10006', '彭璐', '女', 56, '144-0250-4252'); INSERT INTO `t_patient` VALUES ('10007', '李睿', '男', 11, '760-5963-6579'); INSERT INTO `t_patient` VALUES ('10008', '叶宇宁', '男', 33, '155-1117-9875'); INSERT INTO `t_patient` VALUES ('10009', '杨睿', '男', 48, '760-1389-9772'); INSERT INTO `t_patient` VALUES ('10010', '熊致远', '男', 11, '20-9278-7287'); INSERT INTO `t_patient` VALUES ('10011', '谭子韬', '男', 11, '10-5460-3302'); INSERT INTO `t_patient` VALUES ('10012', '龙云熙', '男', 36, '769-625-8369'); INSERT INTO `t_patient` VALUES ('10013', '潘睿', '男', 15, '146-5460-0503'); INSERT INTO `t_patient` VALUES ('10014', '胡嘉伦', '男', 23, '144-0725-3728'); INSERT INTO `t_patient` VALUES ('10015', '陶睿', '男', 50, '144-4354-4812'); INSERT INTO `t_patient` VALUES ('10016', '顾震南', '男', 33, '755-837-7148'); INSERT INTO `t_patient` VALUES ('10017', '袁岚', '女', 49, '173-5836-5107'); INSERT INTO `t_patient` VALUES ('10018', '卢詩涵', '女', 58, '760-176-4450'); INSERT INTO `t_patient` VALUES ('10019', '李璐', '女', 22, '20-8392-9908'); INSERT INTO `t_patient` VALUES ('10020', '蔡詩涵', '女', 27, '190-8099-9579'); INSERT INTO `t_patient` VALUES ('10021', '吕子异', '男', 23, '28-205-6374'); INSERT INTO `t_patient` VALUES ('10022', '侯詩涵', '女', 25, '20-4328-8586'); INSERT INTO `t_patient` VALUES ('10023', '孔睿', '男', 58, '769-118-9579'); INSERT INTO `t_patient` VALUES ('10024', '徐嘉伦', '男', 33, '21-0131-1452'); INSERT INTO `t_patient` VALUES ('10025', '傅安琪', '女', 17, '760-074-2030'); INSERT INTO `t_patient` VALUES ('10026', '蒋致远', '男', 49, '154-1502-8322'); INSERT INTO `t_patient` VALUES ('10027', '何云熙', '男', 11, '760-7767-9468'); INSERT INTO `t_patient` VALUES ('10028', '朱秀英', '女', 57, '28-951-6412'); INSERT INTO `t_patient` VALUES ('10029', '萧睿', '男', 16, '169-1837-9488'); INSERT INTO `t_patient` VALUES ('10030', '苏宇宁', '男', 28, '769-6418-4954'); INSERT INTO `t_patient` VALUES ('10031', '马睿', '男', 44, '21-868-2371'); INSERT INTO `t_patient` VALUES ('10032', '吴晓明', '男', 46, '138-8679-0662'); INSERT INTO `t_patient` VALUES ('10033', '汪震南', '男', 55, '156-1029-5325'); INSERT INTO `t_patient` VALUES ('10034', '陆嘉伦', '男', 12, '755-081-8243'); INSERT INTO `t_patient` VALUES ('10035', '韩致远', '男', 14, '28-3673-8413'); INSERT INTO `t_patient` VALUES ('10036', '陶詩涵', '女', 42, '185-8722-8093'); INSERT INTO `t_patient` VALUES ('10037', '秦璐', '女', 60, '769-275-5209'); INSERT INTO `t_patient` VALUES ('10038', '余致远', '男', 20, '179-1132-3645'); INSERT INTO `t_patient` VALUES ('10039', '梁云熙', '男', 39, '21-7784-6260'); INSERT INTO `t_patient` VALUES ('10040', '刘晓明', '男', 50, '143-5309-6600'); INSERT INTO `t_patient` VALUES ('10041', '贺杰宏', '男', 14, '760-9388-2272'); INSERT INTO `t_patient` VALUES ('10042', '廖子异', '男', 54, '10-700-0511'); INSERT INTO `t_patient` VALUES ('10043', '邵致远', '男', 45, '769-970-5598'); INSERT INTO `t_patient` VALUES ('10044', '常子韬', '男', 44, '142-2894-9338'); INSERT INTO `t_patient` VALUES ('10045', '龚睿', '男', 42, '760-8312-1246'); INSERT INTO `t_patient` VALUES ('10046', '雷秀英', '女', 34, '755-2071-2097'); INSERT INTO `t_patient` VALUES ('10047', '钟晓明', '男', 55, '769-301-9665'); INSERT INTO `t_patient` VALUES ('10048', '黎致远', '男', 39, '20-9401-0460'); INSERT INTO `t_patient` VALUES ('10049', '马杰宏', '男', 44, '142-4147-4122'); INSERT INTO `t_patient` VALUES ('10050', '魏云熙', '男', 35, '21-6786-3131'); -- ---------------------------- -- Table structure for t_registration -- ---------------------------- DROP TABLE IF EXISTS `t_registration`; CREATE TABLE `t_registration` ( `rid` int(10) NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL, `did` int(10) NULL DEFAULT NULL, `rtime` date NULL DEFAULT NULL, PRIMARY KEY (`rid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 490051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_registration -- ---------------------------- INSERT INTO `t_registration` VALUES (1, 10007, 10001, '2006-12-31'); INSERT INTO `t_registration` VALUES (10002, 10049, 10011, '2017-07-12'); INSERT INTO `t_registration` VALUES (20003, 10037, 10013, '2004-05-08'); INSERT INTO `t_registration` VALUES (30004, 10005, 10018, '2001-02-22'); INSERT INTO `t_registration` VALUES (40005, 10039, 10015, '2021-04-24'); INSERT INTO `t_registration` VALUES (50006, 10011, 10011, '2019-05-11'); INSERT INTO `t_registration` VALUES (60007, 10035, 10002, '2010-02-10'); INSERT INTO `t_registration` VALUES (70008, 10018, 10005, '2000-03-18'); INSERT INTO `t_registration` VALUES (80009, 10032, 10005, '2021-04-01'); INSERT INTO `t_registration` VALUES (90010, 10034, 10009, '2007-03-04'); INSERT INTO `t_registration` VALUES (100011, 10014, 10013, '2022-12-28'); INSERT INTO `t_registration` VALUES (110012, 10026, 10015, '2018-04-25'); INSERT INTO `t_registration` VALUES (120013, 10009, 10019, '2011-09-05'); INSERT INTO `t_registration` VALUES (130014, 10021, 10007, '2015-09-24'); INSERT INTO `t_registration` VALUES (140015, 10020, 10004, '2013-10-02'); INSERT INTO `t_registration` VALUES (150016, 10013, 10009, '2016-11-15'); INSERT INTO `t_registration` VALUES (160017, 10038, 10013, '2018-10-03'); INSERT INTO `t_registration` VALUES (170018, 10044, 10012, '2018-03-07'); INSERT INTO `t_registration` VALUES (180019, 10048, 10003, '2004-08-09'); INSERT INTO `t_registration` VALUES (190020, 10043, 10012, '2017-05-18'); INSERT INTO `t_registration` VALUES (200021, 10016, 10017, '2011-10-07'); INSERT INTO `t_registration` VALUES (210022, 10012, 10005, '2005-12-14'); INSERT INTO `t_registration` VALUES (220023, 10010, 10004, '2018-07-20'); INSERT INTO `t_registration` VALUES (230024, 10002, 10011, '2023-11-06'); INSERT INTO `t_registration` VALUES (240025, 10017, 10010, '2016-11-26'); INSERT INTO `t_registration` VALUES (250026, 10033, 10011, '2004-12-03'); INSERT INTO `t_registration` VALUES (260027, 10022, 10020, '2005-09-12'); INSERT INTO `t_registration` VALUES (270028, 10040, 10015, '2012-02-08'); INSERT INTO `t_registration` VALUES (280029, 10008, 10010, '2023-08-05'); INSERT INTO `t_registration` VALUES (290030, 10045, 10013, '2009-01-15'); INSERT INTO `t_registration` VALUES (300031, 10028, 10010, '2005-10-26'); INSERT INTO `t_registration` VALUES (310032, 10024, 10016, '2007-02-05'); INSERT INTO `t_registration` VALUES (320033, 10006, 10012, '2005-01-09'); INSERT INTO `t_registration` VALUES (330034, 10036, 10009, '2012-07-04'); INSERT INTO `t_registration` VALUES (340035, 10015, 10010, '2016-01-14'); INSERT INTO `t_registration` VALUES (350036, 10025, 10007, '2007-07-16'); INSERT INTO `t_registration` VALUES (360037, 10046, 10009, '2003-11-21'); INSERT INTO `t_registration` VALUES (370038, 10042, 10019, '2015-08-22'); INSERT INTO `t_registration` VALUES (380039, 10047, 10008, '2003-12-11'); INSERT INTO `t_registration` VALUES (390040, 10030, 10011, '2023-11-03'); INSERT INTO `t_registration` VALUES (400041, 10041, 10011, '2009-10-31'); INSERT INTO `t_registration` VALUES (410042, 10001, 10015, '2016-01-28'); INSERT INTO `t_registration` VALUES (420043, 10029, 10020, '2001-01-31'); INSERT INTO `t_registration` VALUES (430044, 10050, 10018, '2015-06-07'); INSERT INTO `t_registration` VALUES (440045, 10031, 10018, '2011-11-30'); INSERT INTO `t_registration` VALUES (450046, 10003, 10004, '2022-06-13'); INSERT INTO `t_registration` VALUES (460047, 10004, 10002, '2017-07-12'); INSERT INTO `t_registration` VALUES (470048, 10027, 10003, '2005-07-13'); INSERT INTO `t_registration` VALUES (480049, 10023, 10019, '2015-05-13'); INSERT INTO `t_registration` VALUES (490050, 10019, 10007, '2011-09-14'); SET FOREIGN_KEY_CHECKS = 1; 第5题/db_dance.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_dance Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 05/01/2024 15:19:43 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_class -- ---------------------------- DROP TABLE IF EXISTS `t_class`; CREATE TABLE `t_class` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tea_id` int(10) NULL DEFAULT NULL, `cou_id` int(10) NULL DEFAULT NULL, `time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_class -- ---------------------------- INSERT INTO `t_class` VALUES (10001, '周末班', 10007, 10005, '周六到周日14-15点'); INSERT INTO `t_class` VALUES (10002, '晚间班', 10009, 10005, '周一到周五19-21点 '); INSERT INTO `t_class` VALUES (10003, '周末班', 10006, 10003, '周六到周日14-15点'); INSERT INTO `t_class` VALUES (10004, '晚间班', 10008, 10004, '周一到周五19-21点 '); INSERT INTO `t_class` VALUES (10005, '周末班', 10010, 10004, '周六到周日14-15点'); INSERT INTO `t_class` VALUES (10006, '晚间班', 10004, 10003, '周一到周五19-21点 '); INSERT INTO `t_class` VALUES (10007, '晚间班', 10001, 10002, '周一到周五19-21点 '); INSERT INTO `t_class` VALUES (10008, '周末班', 10003, 10001, '周六到周日14-15点'); INSERT INTO `t_class` VALUES (10009, '晚间班', 10002, 10001, '周一到周五19-21点 '); INSERT INTO `t_class` VALUES (10010, '周末班', 10005, 10002, '周六到周日14-15点'); -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `period` int(5) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10006 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '街舞', 48); INSERT INTO `t_course` VALUES (10002, '芭蕾舞', 48); INSERT INTO `t_course` VALUES (10003, '古典舞', 48); INSERT INTO `t_course` VALUES (10004, '形体课', 24); INSERT INTO `t_course` VALUES (10005, '瑜伽课', 36); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(3) NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cls_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '杨詩涵', '女', 14, '156-9749-4103', 10004); INSERT INTO `t_student` VALUES (10002, '郝晓明', '男', 20, '28-174-4198', 10002); INSERT INTO `t_student` VALUES (10003, '孙子韬', '男', 21, '156-3813-6615', 10005); INSERT INTO `t_student` VALUES (10004, '贺安琪', '女', 17, '187-6178-5991', 10006); INSERT INTO `t_student` VALUES (10005, '孔子韬', '男', 17, '21-624-3205', 10010); INSERT INTO `t_student` VALUES (10006, '武震南', '男', 18, '760-5392-5374', 10008); INSERT INTO `t_student` VALUES (10007, '刘震南', '男', 19, '187-6357-4724', 10004); INSERT INTO `t_student` VALUES (10008, '孔晓明', '男', 13, '28-681-0499', 10006); INSERT INTO `t_student` VALUES (10009, '董致远', '男', 15, '198-9626-7436', 10009); INSERT INTO `t_student` VALUES (10010, '于致远', '男', 22, '195-9972-2529', 10010); INSERT INTO `t_student` VALUES (10011, '孟子韬', '男', 20, '20-4120-9260', 10003); INSERT INTO `t_student` VALUES (10012, '常睿', '男', 14, '186-7087-2697', 10008); INSERT INTO `t_student` VALUES (10013, '何子异', '男', 15, '760-6079-5173', 10005); INSERT INTO `t_student` VALUES (10014, '邵嘉伦', '男', 19, '760-397-6748', 10008); INSERT INTO `t_student` VALUES (10015, '莫震南', '男', 19, '10-2148-5484', 10002); INSERT INTO `t_student` VALUES (10016, '金睿', '男', 13, '769-744-0532', 10006); INSERT INTO `t_student` VALUES (10017, '戴致远', '男', 18, '20-294-5771', 10006); INSERT INTO `t_student` VALUES (10018, '陈云熙', '男', 13, '183-3750-2872', 10002); INSERT INTO `t_student` VALUES (10019, '武子异', '男', 14, '760-202-9085', 10004); INSERT INTO `t_student` VALUES (10020, '蔡睿', '男', 17, '28-890-3668', 10003); INSERT INTO `t_student` VALUES (10021, '谭致远', '男', 19, '133-4773-0375', 10004); INSERT INTO `t_student` VALUES (10022, '段嘉伦', '男', 13, '145-3076-9459', 10008); INSERT INTO `t_student` VALUES (10023, '傅岚', '女', 19, '28-8336-0546', 10009); INSERT INTO `t_student` VALUES (10024, '陈睿', '男', 14, '196-6023-1698', 10009); INSERT INTO `t_student` VALUES (10025, '苏秀英', '女', 14, '28-390-5998', 10001); INSERT INTO `t_student` VALUES (10026, '萧睿', '男', 18, '755-1760-5398', 10007); INSERT INTO `t_student` VALUES (10027, '程安琪', '女', 17, '10-4383-5598', 10002); INSERT INTO `t_student` VALUES (10028, '赵震南', '男', 13, '138-8274-2389', 10005); INSERT INTO `t_student` VALUES (10029, '毛宇宁', '男', 13, '769-816-1618', 10003); INSERT INTO `t_student` VALUES (10030, '邵晓明', '男', 20, '760-475-2476', 10001); INSERT INTO `t_student` VALUES (10031, '郑晓明', '男', 20, '130-3168-8051', 10007); INSERT INTO `t_student` VALUES (10032, '杜秀英', '女', 18, '175-3388-0464', 10007); INSERT INTO `t_student` VALUES (10033, '尹安琪', '女', 16, '10-9148-9502', 10010); INSERT INTO `t_student` VALUES (10034, '罗安琪', '女', 16, '769-078-5957', 10005); INSERT INTO `t_student` VALUES (10035, '陈杰宏', '男', 18, '157-9612-4864', 10009); INSERT INTO `t_student` VALUES (10036, '梁睿', '男', 18, '169-1188-6225', 10010); INSERT INTO `t_student` VALUES (10037, '杨子韬', '男', 13, '143-2959-3789', 10003); INSERT INTO `t_student` VALUES (10038, '叶震南', '男', 19, '173-8465-6772', 10001); INSERT INTO `t_student` VALUES (10039, '方杰宏', '男', 21, '760-2259-4448', 10007); INSERT INTO `t_student` VALUES (10040, '叶子韬', '男', 18, '168-5655-3892', 10001); INSERT INTO `t_student` VALUES (10041, '江杰宏', '男', 21, '134-4548-9932', 10004); INSERT INTO `t_student` VALUES (10042, '姚秀英', '女', 17, '21-253-4481', 10009); INSERT INTO `t_student` VALUES (10043, '江致远', '男', 14, '136-8904-2737', 10008); INSERT INTO `t_student` VALUES (10044, '萧詩涵', '女', 17, '169-6038-7203', 10001); INSERT INTO `t_student` VALUES (10045, '孙子韬', '男', 15, '760-3920-3293', 10006); INSERT INTO `t_student` VALUES (10046, '叶致远', '男', 13, '769-673-7543', 10008); INSERT INTO `t_student` VALUES (10047, '郭睿', '男', 21, '28-926-7582', 10003); INSERT INTO `t_student` VALUES (10048, '侯岚', '女', 21, '769-6339-8485', 10003); INSERT INTO `t_student` VALUES (10049, '金宇宁', '男', 19, '174-1509-6774', 10001); INSERT INTO `t_student` VALUES (10050, '郑宇宁', '男', 22, '769-684-4214', 10009); -- ---------------------------- -- Table structure for t_teacher -- ---------------------------- DROP TABLE IF EXISTS `t_teacher`; CREATE TABLE `t_teacher` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(3) NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_teacher -- ---------------------------- INSERT INTO `t_teacher` VALUES (10001, '毛岚', '女', 32, '141-2488-8388'); INSERT INTO `t_teacher` VALUES (10002, '阎璐', '女', 31, '755-797-4098'); INSERT INTO `t_teacher` VALUES (10003, '徐宇宁', '男', 26, '156-9777-4532'); INSERT INTO `t_teacher` VALUES (10004, '罗云熙', '男', 35, '168-2861-0381'); INSERT INTO `t_teacher` VALUES (10005, '郑岚', '女', 26, '755-117-8789'); INSERT INTO `t_teacher` VALUES (10006, '韩杰宏', '男', 34, '755-801-7051'); INSERT INTO `t_teacher` VALUES (10007, '谢子异', '男', 30, '755-286-0780'); INSERT INTO `t_teacher` VALUES (10008, '侯睿', '男', 28, '135-3705-3061'); INSERT INTO `t_teacher` VALUES (10009, '林岚', '女', 31, '147-4778-0303'); INSERT INTO `t_teacher` VALUES (10010, '钱杰宏', '男', 26, '165-0043-6486'); SET FOREIGN_KEY_CHECKS = 1; 第6题/db_treatment.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_treatment Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 16/11/2023 10:16:06 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_doctor -- ---------------------------- DROP TABLE IF EXISTS `tb_doctor`; CREATE TABLE `tb_doctor` ( `did` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `office` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`did`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_doctor -- ---------------------------- INSERT INTO `tb_doctor` VALUES ('d0001', '李医生', '儿童科', '主任', '1809999999'); INSERT INTO `tb_doctor` VALUES ('d0002', '王医生', '外科', '高级医生', '1897777777'); INSERT INTO `tb_doctor` VALUES ('d0003', '刘医生', '内科', '院长', '1596666666'); INSERT INTO `tb_doctor` VALUES ('d0004', '赵医生', '耳鼻喉科', '实习医生', '1329999999'); INSERT INTO `tb_doctor` VALUES ('d0005', '吴医生', '耳鼻喉科', '主任', '1341111111'); INSERT INTO `tb_doctor` VALUES ('d0006', '方医生', '急症室', '高级医生', '1378888888'); -- ------$ 编写说明：湖北省技能高考《计算机类考纲百套卷》,依据《湖北省普通高等学校招收中等职业学校毕业生技能高考计算机类技能考试大纲》编写。每门课程均分三层训练：基础层(具象化支架)以拆解考点为微目标,紧扣考纲 掌握理解 要求编写考点训练卷；巩固层(关联性支架)强化知识交叉与场景关联,按考纲专题编专题训练卷；应用层(引导性支架)聚焦真题突破,结合知识模块与教材编写课程综合卷。 本试卷是第71卷,按《MySQL数据库基础》范围和要求编写。具体内容为:掌握SQL查询的基本概念,熟练掌握简单查询、统计函数查询、条件查询的操作方法 湖北省《计算机类考纲百套卷》 第71卷 《MySQL数据库基础》 数据库的基本查询 考点训练卷 考试时间80分钟 满分100分 班级 姓名 学号 成绩 一、数据库操作题(本大题共10小题,每题10分,共100分) 1.社交网络数据库db_social包含了t_user用户表、t_friendship好友关系表、t_post动态表、点赞表 t_user包含字段uid(用户编号),username(用户名),password(密码),nickname(昵称),age(年龄),sex(性别)。 t_friendship包含字段 fsid(好友关系编号),uid(用户id),fid(好友id),createtime(添加时间)。 t_post包含字段pid(动态编号),uid(用户编号),content(内容),createtime(创建时间) t_likes包含字段lid(点赞编号),pid(动态编号),fid(好友id),createtime(点赞时间)。 (1).查询所有年龄大于等于18岁的男性用户的用户名和昵称。 (2).查询昵称中包含小字的所有用户信息。 (3).统计每位用户发布的动态数量,显示用户编号和动态条数。 (4).查询2025年6月1日当天发布的全部动态,显示发布用户昵称、动态内容和发布时间。 (5).统计每条动态的点赞数量,显示动态编号、动态内容和点赞数,按点赞数降序排列。 (6).查询从未发布过任何动态的用户编号和用户名 答案: (1).SELECT username, nickname FROM t_user WHERE age >= 18 AND sex = '男'; (2).SELECT * FROM t_user WHERE nickname LIKE '%小%'; (3).SELECT uid, COUNT(*) AS post_count FROM t_post GROUP BY uid; (4).SELECT u.nickname, p.content, p.createtime FROM t_post p JOIN t_user u ON p.uid = u.uid WHERE DATE(p.createtime) = '2025-06-01'; (5).SELECT p.pid, p.content, COUNT(l.pid) AS like_count FROM t_post p LEFT JOIN t_likes l ON p.pid = l.pid GROUP BY p.pid ORDER BY like_count DESC; (6).SELECT uid, username FROM t_user WHERE uid NOT IN (SELECT DISTINCT uid FROM t_post); 2.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段sid(学生编号),sname(学生姓名),username(用户名),password(密码),classes(班级)。 t_course包含字段 cid(课程编号),cname(课程名称),description(描述), classhour(课时)。 t_video包括字段vid(视频编号),cid(课程编号),title(标题),link(链接地址) t_Learn学习记录表lid(学习记录编号),sid(学生编号),cid(课程编号),schedule(学习进度),createtime(创建时间)。 (1).查询所有班级为计算机科学与技术1班的学生姓名和用户名。 (2).查询课时数大于等于32的所有课程的名称和课时数。 (3).统计每门课程拥有的视频数量,显示课程名称和视频数量。 (4).查询学习进度大于80%的学习记录,显示学生姓名、课程名称和学习进度。 (5).统计每位学生的学习课程门数,显示学生姓名和学习课程数量。 (6).查询2025年5月份的所有学习记录,显示学生姓名、课程名称和创建时间 答案: (1).SELECT sname, username FROM t_student WHERE classes = '计算机科学与技术1班'; (2).SELECT cname, classhour FROM t_course WHERE classhour >= 32; (3).SELECT c.cname, COUNT(v.vid) AS video_count FROM t_course c LEFT JOIN t_video v ON c.cid = v.cid GROUP BY c.cid; (4).SELECT s.sname, c.cname, l.schedule FROM t_learn l JOIN t_student s ON l.sid = s.sid JOIN t_course c ON l.cid = c.cid WHERE l.schedule > 80; (5).SELECT s.sname, COUNT(l.cid) AS course_count FROM t_student s LEFT JOIN t_learn l ON s.sid = l.sid GROUP BY s.sid; (6).SELECT s.sname, c.cname, l.createtime FROM t_learn l JOIN t_student s ON l.sid = s.sid JOIN t_course c ON l.cid = c.cid WHERE YEAR(l.createtime) = 2025 AND MONTH(l.createtime) = 5; 3.学生成绩系统数据库db_grade包含了t_student学生表t_grade成绩表和t_course科目表 t_student包含字段sid(学生编号),sname(姓名),sex(性别),class(班级)。 t_course包含字段 cid(科目编号),cname(科目名称),total(总分)。 t_grade包含字段gid(成绩编号),sid(学生编号),cid(科目编号),score(分数)。 (1).查询所有女生的姓名和班级。 (2).查询成绩在60分到80分之间的所有成绩记录,显示学生姓名、科目名称和分数。 (3).统计每位学生的总分,显示学生姓名和总分,按总分降序排列。 (4).查询每门科目的平均分,显示科目名称和平均分(保留两位小数)。 (5).查询张三同学的所有科目成绩,显示科目名称和分数。 (6).查询缺考(未登记成绩)的学生姓名和学号 答案: (1).SELECT sname, class FROM t_student WHERE sex = '女'; (2).SELECT s.sname, c.cname, g.score FROM t_grade g JOIN t_student s ON g.sid = s.sid JOIN t_course c ON g.cid = c.cid WHERE g.score BETWEEN 60 AND 80; (3).SELECT s.sname, SUM(g.score) AS total_score FROM t_student s JOIN t_grade g ON s.sid = g.sid GROUP BY s.sid ORDER BY total_score DESC; (4).SELECT c.cname, ROUND(AVG(g.score), 2) AS avg_score FROM t_course c JOIN t_grade g ON c.cid = g.cid GROUP BY c.cid; (5).SELECT c.cname, g.score FROM t_grade g JOIN t_student s ON g.sid = s.sid JOIN t_course c ON g.cid = c.cid WHERE s.sname = '张三'; (6).SELECT sid, sname FROM t_student WHERE sid NOT IN (SELECT DISTINCT sid FROM t_grade); 4.医疗管理数据库db_treatment包含了t_patient患者表、t_doctor医生表、t_registration挂号表 t_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 t_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 t_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 (1).查询所有年龄大于60岁的男性患者的姓名和联系电话。 (2).查询职称为主治医师的医生姓名和科室。 (3).统计每位医生的接诊人数,显示医生姓名和接诊人数,按接诊人数降序排列。 (4).查询2025年6月份的所有挂号记录,显示患者姓名、医生姓名和挂号日期。 (5).统计内科(office=内科)医生的人数。 (6)查询从未挂过号的患者姓名和联系电话 答案: (1).SELECT pname, tel FROM t_patient WHERE age > 60 AND sex = '男'; (2).SELECT dname, office FROM t_doctor WHERE title = '主治医师'; (3).SELECT d.dname, COUNT(r.rid) AS patient_count FROM t_doctor d LEFT JOIN t_registration r ON d.did = r.did GROUP BY d.did ORDER BY patient_count DESC; (4).SELECT p.pname, d.dname, r.rtime FROM t_registration r JOIN t_patient p ON r.pid = p.pid JOIN t_doctor d ON r.did = d.did WHERE YEAR(r.rtime) = 2025 AND MONTH(r.rtime) = 6; (5).SELECT COUNT(*) FROM t_doctor WHERE office = '内科'; (6).SELECT pname, tel FROM t_patient WHERE pid NOT IN (SELECT DISTINCT pid FROM t_registration); 5.舞蹈课程管理系统数据库db_dance包含了t_student学员表、t_course课程表 、t_class班级表和t_teacher老师表。 t_student包含字段id(学生编号),name(学生姓名),sex(性别),age(年龄),tel(联系方式),cls_id(班级编号); t_course包含字段id(课程编号),name(课程名称),period(课时) t_class包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式); (1).查询所有年龄在18至25岁之间的女性学员姓名和联系电话。 (2).查询课时数大于20的所有课程名称和课时数。 (3).统计每位老师所带班级的数量,显示老师姓名和班级数量。 (4).查询拉丁舞课程的所有班级上课时间。 (5).统计每个班级的学员人数,显示班级名称和学员人数。 (6).查询所有未分配班级的学员姓名和年龄 答案: (1).SELECT name, tel FROM t_student WHERE age BETWEEN 18 AND 25 AND sex = '女'; (2).SELECT name, period FROM t_course WHERE period > 20; (3).SELECT t.name, COUNT(c.id) AS class_count FROM t_teacher t LEFT JOIN t_class c ON t.id = c.tea_id GROUP BY t.id; (4).SELECT c.time FROM t_class c JOIN t_course co ON c.cou_id = co.id WHERE co.name = '拉丁舞'; (5).SELECT c.name, COUNT(s.id) AS student_count FROM t_class c LEFT JOIN t_student s ON c.id = s.cls_id GROUP BY c.id; (6).SELECT name, age FROM t_student WHERE cls_id IS NULL; 6.医疗管理数据库db_treatment包含了tb_patient患者表、tb_doctor医生表和tb_registration挂号表 tb_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 tb_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 tb_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 (1).查询所有联系电话以139开头的患者姓名。 (2).查询2025年5月1日至2025年5月31日期间的所有挂号记录。 (3).统计每位患者的挂号次数,显示患者姓名和挂号次数。 (4).查询副主任医师及以上职称(副主任医师、主任医师)的医生姓名和科室。 (5).查询所有未挂过号的患者姓名和年龄。 (6).统计各科室的挂号总人次,显示科室名称和挂号人次 答案: (1).SELECT pname FROM tb_patient WHERE tel LIKE '139%'; (2).SELECT * FROM tb_registration WHERE rtime BETWEEN '2025-05-01' AND '2025-05-31 23:59:59'; (3).SELECT p.pname, COUNT(r.rid) AS reg_count FROM tb_patient p LEFT JOIN tb_registration r ON p.pid = r.pid GROUP BY p.pid; (4).SELECT dname, office FROM tb_doctor WHERE title IN ('副主任医师', '主任医师'); (5).SELECT pname, age FROM tb_patient WHERE pid NOT IN (SELECT DISTINCT pid FROM tb_registration); (6).SELECT d.office, COUNT(r.rid) AS reg_count FROM tb_doctor d LEFT JOIN tb_registration r ON d.did = r.did GROUP BY d.office; 7.舞蹈课程管理系统数据库db_dance包含了t_student学员表、t_course课程表 、t_class班级表和t_teacher老师表。 t_student包含字段id(学生编号),name(学生姓名),sex(性别),age(年龄),tel(联系方式),cls_id(班级编号); t_course包含字段id(课程编号),name(课程名称),period(课时) t_class包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式),salary(薪资); (1).查询所有年龄小于等于15岁的男性学员姓名和年龄。 (2).查询薪资在5000至10000元之间的女老师姓名和薪资。 (3).统计每种课程的总课时数,显示课程名称和总课时。 (4).查询周一上课的所有班级名称和上课时间。 (5).统计每个班级的学员人数,显示班级名称和学员人数。 (6).查询学员人数最多的班级名称和人数 答案: (1).SELECT name, age FROM t_student WHERE age <= 15 AND sex = '男'; (2).SELECT name, salary FROM t_teacher WHERE sex = '女' AND salary BETWEEN 5000 AND 10000; (3).SELECT c.name, SUM(c.period) AS total_period FROM t_course c JOIN t_class cl ON c.id = cl.cou_id GROUP BY c.id; (4).SELECT name, time FROM t_class WHERE time LIKE '周一%'; (5).SELECT c.name, COUNT(s.id) AS student_count FROM t_class c LEFT JOIN t_student s ON c.id = s.cls_id GROUP BY c.id; (6).SELECT c.name, COUNT(s.id) AS student_count FROM t_class c JOIN t_student s ON c.id = s.cls_id GROUP BY c.id ORDER BY student_count DESC LIMIT 1; 8.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段id(学生编号),name(学生姓名),username(用户名),password(密码)。 t_course包含字段 id(课程编号),name(课程名称),description(描述),period(课时)。 t_video包括字段id(视频编号),c_id(课程编号),title(标题),link(链接地址) t_learn学习记录表id(学习记录编号),s_id(学生编号),c_id(课程编号),schedule(学习进度),createtime(创建时间)。 (1).查询用户名以admin开头的所有学生姓名。 (2).查询描述中包含入门二字的课程名称和描述。 (3).统计每门课程的学习记录总数,显示课程名称和学习人数。 (4).查询学习进度为100%(已完成)的学习记录,显示学生姓名、课程名称。 (5).统计每位学生的平均学习进度,显示学生姓名和平均进度(保留一位小数)。 (6).查询2025年1月1日之后有学习记录的所有学生姓名 答案: (1).SELECT name FROM t_student WHERE username LIKE 'admin%'; (2).SELECT name, description FROM t_course WHERE description LIKE '%入门%'; (3).SELECT c.name, COUNT(l.id) AS learn_count FROM t_course c LEFT JOIN t_learn l ON c.id = l.c_id GROUP BY c.id; (4).SELECT s.name, c.name FROM t_learn l JOIN t_student s ON l.s_id = s.id JOIN t_course c ON l.c_id = c.id WHERE l.schedule = 100; (5).SELECT s.name, ROUND(AVG(l.schedule), 1) AS avg_schedule FROM t_student s LEFT JOIN t_learn l ON s.id = l.s_id GROUP BY s.id; (6).SELECT DISTINCT s.name FROM t_student s JOIN t_learn l ON s.id = l.s_id WHERE l.createtime >= '2025-01-01'; 9.人力资源管理系统数据库db_hrm包含了t_employee员工表、t_department部门表和t_salary薪资表 t_employee包含字段id(员工编号),name(员工姓名),sex(性别),age(年龄),position(职位),d_id(部门编号)。 t_department包含字段 id(部门编号),name(部门名称),description(部门描述)。 t_salary包含字段id(薪资编号),e_id(员工编号),money(薪资),time(薪资日期) (1).查询所有技术部员工的姓名、职位和年龄。 (2).查询年龄在30至40岁之间的女性员工的姓名和职位。 (3).统计各部门的员工人数,显示部门名称和员工人数。 (4).查询2025年6月份所有薪资记录,显示员工姓名、薪资额和薪资日期。 (5).统计每位员工的平均薪资,显示员工姓名和平均薪资(保留两位小数)。 (6).查询薪资高于8000元的员工姓名、职位和薪资额 答案: (1).SELECT e.name, e.position, e.age FROM t_employee e JOIN t_department d ON e.d_id = d.id WHERE d.name = '技术部'; (2).SELECT name, position FROM t_employee WHERE age BETWEEN 30 AND 40 AND sex = '女'; (3).SELECT d.name, COUNT(e.id) AS emp_count FROM t_department d LEFT JOIN t_employee e ON d.id = e.d_id GROUP BY d.id; (4).SELECT e.name, s.money, s.time FROM t_salary s JOIN t_employee e ON s.e_id = e.id WHERE YEAR(s.time) = 2025 AND MONTH(s.time) = 6; (5).SELECT e.name, ROUND(AVG(s.money), 2) AS avg_salary FROM t_salary s JOIN t_employee e ON s.e_id = e.id GROUP BY e.id; (6).SELECT e.name, e.position, s.money FROM t_salary s JOIN t_employee e ON s.e_id = e.id WHERE s.money > 8000; 10.人力资源管理系统数据库db_hrm包含了t_employee员工表、t_department部门表和t_salary薪资表 t_employee包含字段id(员工编号),name(员工姓名),sex(性别),age(年龄),position(职位),d_id(部门编号)。 t_department包含字段 id(部门编号),name(部门名称),description(部门描述)。 t_salary包含字段id(薪资编号),e_id(员工编号),money(薪资),time(薪资日期) (1).查询所有年龄大于45岁的男性员工的姓名和职位。 (2).查询职位为经理或总监的员工姓名和所在部门名称。 (3).统计2025年各月份的薪资发放总额,显示月份和总额。 (4).查询产品部所有员工的姓名和年龄,按年龄降序排列。 (5).统计各部门的平均薪资,显示部门名称和平均薪资(保留两位小数)。 (6).查询薪资最高和最低的员工姓名及薪资额 答案: (1).SELECT name, position FROM t_employee WHERE age > 45 AND sex = '男'; (2).SELECT e.name, d.name AS dept_name FROM t_employee e JOIN t_department d ON e.d_id = d.id WHERE e.position IN ('经理', '总监'); (3).SELECT DATE_FORMAT(time, '%Y-%m') AS month, SUM(money) AS total FROM t_salary WHERE YEAR(time) = 2025 GROUP BY DATE_FORMAT(time, '%Y-%m'); (4).SELECT e.name, e.age FROM t_employee e JOIN t_department d ON e.d_id = d.id WHERE d.name = '产品部' ORDER BY e.age DESC; (5).SELECT d.name, ROUND(AVG(s.money), 2) AS avg_salary FROM t_salary s JOIN t_employee e ON s.e_id = e.id JOIN t_department d ON e.d_id = d.id GROUP BY d.id; (6).SELECT e.name, s.money FROM t_salary s JOIN t_employee e ON s.e_id = e.id WHERE s.money = (SELECT MAX(money) FROM t_salary) UNIONSELECT e.name, s.money FROM t_salary s JOIN t_employee e ON s.e_id = e.id WHERE s.money = (SELECT MIN(money) FROM t_salary); 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 $