期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）

《MySQL数据库基础》 期末复习卷(四) 时间:90分钟 总分:100分 班级 姓名 学号 成绩 一.数据库操作题(本大题共5小题,每小题20分,共100分) 1.舞蹈课程管理系统数据库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_clsss包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式) 1).t_teacher表中添加entry_date(入职日期)字段,类型为 date,默认为 2024-01-01 2).添加一条老师数据,id:10033,name:赵雅芝,sex:女,age:32,tel:15912345678,entry_date:2023-06-15 3).使用SQL语句查询年龄大于 25 岁的男学员和女学员人数,要求显示字段:性别、人数(该字段名称显示为count) 4).使用SQL语句查询周三和周五上课的学生信息 5).使用SQL语句查询带班数量超过 2 个班级的老师信息 6).查询没有被任何学生选择的课程信息,显示字段:课程名称、课时 7).创建视图名称为 v_teacher_course,要求显示老师代班信息,显示字段名为:老师姓名、班级名称、课程名称、上课时间 答案: 1).ALTER TABLE t_teacher ADD entry_date DATE DEFAULT '2024-01-01'; 2).INSERT INTO t_teacher (id, name, sex, age, tel, entry_date) VALUES (10033, '赵雅芝', '女', 32, '15912345678', '2023-06-15'); 3).SELECT sex, COUNT(*) AS count FROM t_student WHERE age > 25 GROUP BY sex; 4).SELECT s.* FROM t_student s JOIN t_class c ON s.cls_id = c.id WHERE c.time LIKE '%周三%' OR c.time LIKE '%周五%'; 5).SELECT t.*, COUNT(c.id) AS class_count FROM t_teacher t JOIN t_class c ON t.id = c.tea_id GROUP BY t.id HAVING COUNT(c.id) > 2; 6).SELECT c.name AS 课程名称, c.period AS 课时FROM t_course c WHERE c.id NOT IN (SELECT DISTINCT cl.cou_id FROM t_class cl JOIN t_student s ON cl.id = s.cls_id WHERE s.id IS NOT NULL); 7).CREATE VIEW v_teacher_course ASSELECT t.name AS 老师姓名, c.name AS 班级名称,co.name AS 课程名称, c.time AS 上课时间 FROM t_class c JOIN t_teacher t ON c.tea_id = t.id JOIN t_course co ON c.cou_id = co.id; 2.医疗管理数据库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).创建一个药品表,名称为 tb_medicine,字段如下: mid(药品编号) char(10) 主键 mname(药品名称)varchar(50) 不能为空 price(单价)decimal(8,2) stock(库存量)int 默认 0 expiry_date(有效期)date 2).往tb_medicine表中添加一条数据,药品编号为 m0020,药品名称为阿莫西林,单价为28.50,库存量为200,有效期为2025-12-31 3).tb_doctor表中修改tel联系电话字段类型为varchar,长度为15 4).tb_patient表中将患者编号为p0005的患者姓名修改为张明伟 5).用SQL语句查询职称不是主任也不是实习的医生信息 6).用SQL语句添加一条挂号信息,挂号编号为r0100,患者编号为p0010,医生编号为d0025,挂号日期为2024-09-15 7).创建视图名称为v_patient_visit,要求显示患者就诊记录,显示字段:患者姓名、医生姓名、科室、挂号日期 答案: 1).CREATE TABLE tb_medicine (mid CHAR(10) PRIMARY KEY, mname VARCHAR(50) NOT NULL,price DECIMAL(8,2),stock INT DEFAULT 0, expiry_date DATE); 2).INSERT INTO tb_medicine (mid, mname, price, stock, expiry_date) VALUES ('m0020', '阿莫西林', 28.50, 200, '2025-12-31'); 3).ALTER TABLE tb_doctor MODIFY tel VARCHAR(15); 4).UPDATE tb_patient SET pname = '张明伟' WHERE pid = 'p0005'; 5).SELECT * FROM tb_doctor WHERE title NOT IN ('主任', '实习'); 6).INSERT INTO tb_registration (rid, pid, did, rtime) VALUES ('r0100', 'p0010', 'd0025', '2024-09-15'); 7).CREATE VIEW v_patient_visit ASSELECT p.pname AS 患者姓名, d.dname AS 医生姓名, d.office AS 科室, r.rtime AS 挂号日期 FROM tb_registration r JOIN tb_patient p ON r.pid = p.pid JOIN tb_doctor d ON r.did = d.did; 3.舞蹈课程管理系统数据库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_clsss包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式),salary(薪资) 1).t_student表中id设置为主键,自动增长(起始值为 1000) 2).添加一条学员数据,学员姓名为林小美,性别为女,年龄为22,联系方式为18612345678,班级编号为 2 3).使用SQL语句查询t_student中年龄最小的 3 个学员信息 4).修改t_class表中周一班的班级名称从周一基础班修改为周一强化班 5).使用 SQL 语句查询每个老师所带班级的数量,查询结果按照老师编号分组显示,要求显示字段名为:老师编号、老师姓名、带班数量 6).使用 SQL 语句查询学员 张小凡 所学的课程名称和上课时间 7).创建视图名称为 v_student_info,要求显示学员详细信息,显示字段名为:学员姓名、班级名称、课程名称、老师姓名、上课时间 答案: 1).ALTER TABLE t_student MODIFY id INT AUTO_INCREMENT;ALTER TABLE t_student AUTO_INCREMENT = 1000; 2).INSERT INTO t_student (name, sex, age, tel, cls_id) VALUES ('林小美', '女', 22, '18612345678', 2); 3).SELECT * FROM t_student ORDER BY age ASC LIMIT 3; 4).UPDATE t_class SET name = '周一强化班' WHERE name = '周一基础班'; 5).SELECT t.id AS 老师编号, t.name AS 老师姓名, COUNT(c.id) AS 带班数量FROM t_teacher t LEFT JOIN t_class c ON t.id = c.tea_id GROUP BY t.id, t.name; 6).SELECT c.name AS 课程名称, cl.time AS 上课时间FROM t_student s JOIN t_class cl ON s.cls_id = cl.id JOIN t_course c ON cl.cou_id = c.id WHERE s.name = '张小凡'; 7).CREATE VIEW v_student_info ASSELECT s.name AS 学员姓名, cl.name AS 班级名称,c.name AS 课程名称, t.name AS 老师姓名, cl.time AS 上课时间FROM t_student s JOIN t_class cl ON s.cls_id = cl.id JOIN t_course c ON cl.cou_id = c.id JOIN t_teacher t ON cl.tea_id = t.id; 4.线上教育数据库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).t_student表添加字段email(邮箱)类型varchar(50),默认为暂无 2).添加一个新的学生,学生姓名为欧阳静,用户名为ouyangjing,密码为123456,邮箱为ouyang@126.com 3).用SQL语句查询t_video表信息,按照课程编号正序排列 4).用SQL语句查询每个学生学习的课程数量,查询结果按照学生姓名进行分组显示,要求显示字段名为:学生姓名、学习课程数量 5).用SQL语句查询学习进度低于30%的学生课程学习记录,显示学生姓名、课程名称、学习进度 6).用SQL语句查询学生周子衡未完成的课程(学习进度小于 100%),要求显示字段名为:学生姓名、课程名称、学习进度 7).创建视图名称为 v_course_video,显示课程视频信息,要求显示字段名称为:课程名称、视频标题、视频链接 答案: 1).ALTER TABLE t_student ADD email VARCHAR(50) DEFAULT '暂无'; 2).INSERT INTO t_student (name, username, password, email) VALUES ('欧阳静', 'ouyangjing', '123456', 'ouyang@126.com'); 3).SELECT * FROM t_video ORDER BY c_id ASC; 4).SELECT s.name AS 学生姓名, COUNT(l.c_id) AS 学习课程数量FROM t_student s LEFT JOIN t_learn l ON s.id = l.s_id GROUP BY s.id, s.name;-- 5).SELECT s.name AS 学生姓名, c.name AS 课程名称, l.schedule AS 学习进度FROM t_learn l JOIN t_student s ON l.s_id = s.idJOIN t_course c ON l.c_id = c.id WHERE l.schedule < 30; 6).SELECT s.name AS 学生姓名, c.name AS 课程名称, l.schedule AS 学习进度 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 s.name = '周子衡' AND l.schedule < 100; 7).CREATE VIEW v_course_video ASSELECT c.name AS 课程名称, v.title AS 视频标题, v.link AS 视频链接FROM t_video v JOIN t_course c ON v.c_id = c.id; 5.人力资源管理系统数据库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).创建一个考勤表,名称为 t_attendance,字段如下: id(考勤编号) int(8) 主键 e_id(员工编号) int(8) 不能为空 att_date(考勤日期) date status(考勤状态)varchar(20) 默认为 正常 remark(备注)varchar(100) 2).添加部门信息,部门编号为10010,部门名称为技术研发部,部门描述为负责公司技术研发工作 3).删除员工编号为10030的员工信息(同时考虑外键约束) 4).将销售部的部门描述修改为负责公司产品销售和市场拓展 5).用SQL语句查询薪资低于4000或者高于10000的薪资信息,显示员工姓名、薪资、薪资日期 6).用SQL语句查询每个职位的平均薪资,分别用列名:职位名称、平均薪资,查询结果按照职位分组显示 7).创建视图名称为v_employee_salary,要求显示员工薪资信息,分别用列名:部门名称、员工姓名、职位、薪资、薪资日期,结果按照薪资从高到低排序 8).创建一个名称为check_salary_before_insert的触发器,用来自动校验薪资数据,具体描述如下:当向t_salary表中添加新薪资记录时,这个触发器检查薪资金额是否小于0,如果小于0则自动设置为0 9).创建一个名称为get_employee_count_by_dept的存储过程统计部门人数,具体描述如下:这个存储过程接收一个部门 ID(dept_id)作为输入参数,数据类型为int,并统计该部门下的员工人数,然后通过输出参数(emp_count)返回这个值,返回值为int类型 答案: 1).CREATE TABLE t_attendance (id INT(8) PRIMARY KEY, e_id INT(8) NOT NULL, att_date DATE,status VARCHAR(20) DEFAULT '正常', remark VARCHAR(100)); 2).INSERT INTO t_department (id, name, description) VALUES (10010, '技术研发部', '负责公司技术研发工作'); 3).DELETE FROM t_salary WHERE e_id = 10030;DELETE FROM t_employee WHERE id = 10030; 4).UPDATE t_department SET description = '负责公司产品销售和市场拓展' WHERE name = '销售部'; 5).SELECT e.name AS 员工姓名, s.money AS 薪资, s.time AS 薪资日期FROM t_salary s JOIN t_employee e ON s.e_id = e.id WHERE s.money < 4000 OR s.money > 10000; 6).SELECT e.position AS 职位名称, AVG(s.money) AS 平均薪资FROM t_salary s JOIN t_employee e ON s.e_id = e.id GROUP BY e.position; 7).CREATE VIEW v_employee_salary ASSELECT d.name AS 部门名称, e.name AS 员工姓名,e.position AS 职位, s.money AS 薪资, s.time AS 薪资日期FROM t_salary s JOIN t_employee e ON s.e_id = e.id JOIN t_department d ON e.d_id = d.id ORDER BY s.money DESC; 8).DELIMITER //CREATE TRIGGER check_salary_before_insertBEFORE INSERT ON t_salaryFOR EACH ROWBEGIN IF NEW.money < 0 THEN SET NEW.money = 0; END IF;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE get_employee_count_by_dept(IN dept_id INT, OUT emp_count INT)BEGIN SELECT COUNT(*) INTO emp_count FROM t_employee WHERE d_id = dept_id;END //DELIMITER ; 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题一/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; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题三/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: 08/01/2024 14:41:46 */ 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) NULL DEFAULT NULL, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `period` int(5) 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, '街舞', 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, `salary` decimal(6, 2) NULL DEFAULT 5000.00, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10012 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_teacher -- ---------------------------- INSERT INTO `t_teacher` VALUES (10001, '毛岚', '女', 32, '141-2488-8388', 5500.00); INSERT INTO `t_teacher` VALUES (10002, '阎璐', '女', 31, '755-797-4098', 6000.00); INSERT INTO `t_teacher` VALUES (10003, '徐宇宁', '男', 26, '156-9777-4532', 5200.00); INSERT INTO `t_teacher` VALUES (10004, '罗云熙', '男', 35, '168-2861-0381', 8000.00); INSERT INTO `t_teacher` VALUES (10005, '郑岚', '女', 26, '755-117-8789', 5000.00); INSERT INTO `t_teacher` VALUES (10006, '韩杰宏', '男', 34, '755-801-7051', 8200.00); INSERT INTO `t_teacher` VALUES (10007, '谢子异', '男', 30, '755-286-0780', 7100.00); INSERT INTO `t_teacher` VALUES (10008, '侯睿', '男', 28, '135-3705-3061', 6800.00); INSERT INTO `t_teacher` VALUES (10009, '林岚', '女', 31, '147-4778-0303', 7500.00); INSERT INTO `t_teacher` VALUES (10010, '钱杰宏', '男', 26, '165-0043-6486', 5000.00); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题二/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'); -- ---------------------------- -- Table structure for tb_patient -- ---------------------------- DROP TABLE IF EXISTS `tb_patient`; CREATE TABLE `tb_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` char(10) 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 (`pid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_patient -- ---------------------------- INSERT INTO `tb_patient` VALUES ('p0001', '刘云', '女', '16', '111111111'); INSERT INTO `tb_patient` VALUES ('p0002', '赵华', '男', '31', '222222222'); INSERT INTO `tb_patient` VALUES ('p0003', '王强', '男', '22', '333333333'); INSERT INTO `tb_patient` VALUES ('p0004', '马汉', '男', '33', '444444444'); INSERT INTO `tb_patient` VALUES ('p0005', '方燕', '女', '21', '55555555'); INSERT INTO `tb_patient` VALUES ('p0006', '王小丽', '女', '55', '66666666'); INSERT INTO `tb_patient` VALUES ('p0007', '陈大强', '男', '77', '77777777'); -- ---------------------------- -- Table structure for tb_registration -- ---------------------------- DROP TABLE IF EXISTS `tb_registration`; CREATE TABLE `tb_registration` ( `rid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `did` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rtime` date NULL DEFAULT NULL, PRIMARY KEY (`rid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_registration -- ---------------------------- INSERT INTO `tb_registration` VALUES ('r0001', 'p0001', 'd0001', '2023-10-30'); INSERT INTO `tb_registration` VALUES ('r0002', 'p0002', 'd0006', '2023-11-01'); INSERT INTO `tb_registration` VALUES ('r0003', 'p0003', 'd0002', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0004', 'p0004', 'd0005', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0005', 'p0005', 'd0004', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0006', 'p0006', 'd0003', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0007', 'p0007', 'd0006', '2023-11-02'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题五/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'); 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题四/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: 16/01/2024 15:44:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 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 NOT NULL `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `period` int(10) NULL DEFAULT NULL PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10004 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); -- ---------------------------- -- Table structure for t_learn -- ---------------------------- DROP TABLE IF EXISTS `t_learn`; CREATE TABLE `t_learn` ( `id` int(10) NOT NULL AUTO_INCREMENT `s_id` int(10) NOT NULL `c_id` int(10) NOT NULL `schedule` int(11) NULL DEFAULT 0 `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10201 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_learn -- ---------------------------- INSERT INTO `t_learn` VALUES (10001 10025 10001 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10002 10032 10001 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10003 10072 10001 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10004 10010 10001 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10005 10045 10001 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10006 10086 10001 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10007 10050 10001 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10008 10046 10001 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10009 10011 10001 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10010 10055 10001 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10011 10044 10001 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10012 10098 10001 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10013 10040 10001 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10014 10074 10001 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10015 10069 10001 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10016 10067 10001 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10017 10087 10001 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10018 10080 10001 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10019 10093 10001 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10020 10028 10001 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10021 10062 10001 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10022 10049 10001 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10023 10039 10001 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10024 10005 10001 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10025 10065 10001 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10026 10047 10001 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10027 10012 10001 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10028 10037 10001 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10029 10018 10001 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10030 10066 10001 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10031 10063 10001 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10032 10090 10001 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10033 10085 10001 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10034 10092 10001 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10035 10060 10001 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10036 10088 10001 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10037 10071 10001 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10038 10079 10001 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10039 10091 10001 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10040 10003 10001 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10041 10083 10001 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10042 10054 10001 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10043 10017 10001 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10044 10021 10001 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10045 10014 10001 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10046 10051 10001 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10047 10035 10001 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10048 10008 10001 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10049 10100 10001 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10050 10016 10001 33 '2024-07-05 11:07:38'); INSERT INTO `t_learn` VALUES (10051 10033 10001 9 '2024-06-27 11:06:15'); INSERT INTO `t_learn` VALUES (10052 10022 10001 15 '2023-11-29 06:00:37'); INSERT INTO `t_learn` VALUES (10053 10082 10001 41 '2024-05-10 13:59:37'); INSERT INTO `t_learn` VALUES (10054 10096 10001 11 '2023-02-27 13:35:38'); INSERT INTO `t_learn` VALUES (10055 10030 10001 27 '2023-01-08 00:29:21'); INSERT INTO `t_learn` VALUES (10056 10029 10001 24 '2024-03-01 05:48:04'); INSERT INTO `t_learn` VALUES (10057 10075 10001 21 '2024-11-09 23:10:32'); INSERT INTO `t_learn` VALUES (10058 10053 10001 1 '2024-10-28 14:38:52'); INSERT INTO `t_learn` VALUES (10059 10041 10001 21 '2024-11-04 06:31:31'); INSERT INTO `t_learn` VALUES (10060 10027 10001 14 '2024-08-30 16:31:07'); INSERT INTO `t_learn` VALUES (10061 10031 10001 30 '2023-05-27 05:01:32'); INSERT INTO `t_learn` VALUES (10062 10052 10001 17 '2024-10-28 01:47:09'); INSERT INTO `t_learn` VALUES (10063 10026 10001 30 '2023-07-09 12:57:40'); INSERT INTO `t_learn` VALUES (10064 10089 10001 15 '2023-10-01 05:36:14'); INSERT INTO `t_learn` VALUES (10065 10043 10001 42 '2024-12-09 18:42:26'); INSERT INTO `t_learn` VALUES (10066 10070 10001 11 '2023-02-18 10:25:15'); INSERT INTO `t_learn` VALUES (10067 10059 10001 11 '2024-03-30 03:20:04'); INSERT INTO `t_learn` VALUES (10068 10001 10001 6 '2024-05-16 09:40:05'); INSERT INTO `t_learn` VALUES (10069 10023 10001 44 '2024-04-21 10:45:41'); INSERT INTO `t_learn` VALUES (10070 10004 10001 3 '2024-08-13 07:19:31'); INSERT INTO `t_learn` VALUES (10071 10076 10001 39 '2024-10-25 10:09:28'); INSERT INTO `t_learn` VALUES (10072 10056 10001 37 '2023-09-01 08:05:29'); INSERT INTO `t_learn` VALUES (10073 10019 10001 40 '2024-06-21 07:31:46'); INSERT INTO `t_learn` VALUES (10074 10002 10001 38 '2023-03-14 18:31:13'); INSERT INTO `t_learn` VALUES (10075 10064 10001 23 '2024-04-01 22:39:29'); INSERT INTO `t_learn` VALUES (10076 10036 10001 44 '2023-08-09 04:24:49'); INSERT INTO `t_learn` VALUES (10077 10078 10001 40 '2024-10-08 05:24:30'); INSERT INTO `t_learn` VALUES (10078 10081 10001 21 '2024-04-09 13:56:25'); INSERT INTO `t_learn` VALUES (10079 10084 10001 39 '2023-08-29 11:57:20'); INSERT INTO `t_learn` VALUES (10080 10038 10001 15 '2024-10-02 13:21:22'); INSERT INTO `t_learn` VALUES (10081 10025 10002 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10082 10032 10002 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10083 10072 10002 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10084 10010 10002 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10085 10045 10002 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10086 10086 10002 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10087 10050 10002 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10088 10046 10002 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10089 10011 10002 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10090 10055 10002 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10091 10044 10002 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10092 10098 10002 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10093 10040 10002 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10094 10074 10002 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10095 10069 10002 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10096 10067 10002 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10097 10087 10002 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10098 10080 10002 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10099 10093 10002 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10100 10028 10002 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10101 10062 10002 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10102 10049 10002 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10103 10039 10002 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10104 10005 10002 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10105 10065 10002 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10106 10047 10002 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10107 10012 10002 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10108 10037 10002 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10109 10018 10002 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10110 10066 10002 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10111 10063 10002 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10112 10090 10002 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10113 10085 10002 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10114 10092 10002 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10115 10060 10002 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10116 10088 10002 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10117 10071 10002 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10118 10079 10002 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10119 10091 10002 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10120 10003 10002 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10121 10083 10002 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10122 10054 10002 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10123 10017 10002 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10124 10021 10002 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10125 10014 10002 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10126 10051 10002 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10127 10035 10002 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10128 10008 10002 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10129 10100 10002 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10130 10016 10002 33 '2024-07-05 11:07:38'); INSERT INTO `t_learn` VALUES (10131 10033 10002 9 '2024-06-27 11:06:15'); INSERT INTO `t_learn` VALUES (10132 10022 10002 15 '2023-11-29 06:00:37'); INSERT INTO `t_learn` VALUES (10133 10082 10002 41 '2024-05-10 13:59:37'); INSERT INTO `t_learn` VALUES (10134 10096 10002 11 '2023-02-27 13:35:38'); INSERT INTO `t_learn` VALUES (10135 10030 10002 27 '2023-01-08 00:29:21'); INSERT INTO `t_learn` VALUES (10136 10029 10002 24 '2024-03-01 05:48:04'); INSERT INTO `t_learn` VALUES (10137 10075 10002 21 '2024-11-09 23:10:32'); INSERT INTO `t_learn` VALUES (10138 10053 10002 1 '2024-10-28 14:38:52'); INSERT INTO `t_learn` VALUES (10139 10041 10002 21 '2024-11-04 06:31:31'); INSERT INTO `t_learn` VALUES (10140 10027 10002 14 '2024-08-30 16:31:07'); INSERT INTO `t_learn` VALUES (10141 10031 10002 30 '2023-05-27 05:01:32'); INSERT INTO `t_learn` VALUES (10142 10052 10002 17 '2024-10-28 01:47:09'); INSERT INTO `t_learn` VALUES (10143 10026 10002 30 '2023-07-09 12:57:40'); INSERT INTO `t_learn` VALUES (10144 10089 10002 15 '2023-10-01 05:36:14'); INSERT INTO `t_learn` VALUES (10145 10043 10002 42 '2024-12-09 18:42:26'); INSERT INTO `t_learn` VALUES (10146 10070 10002 11 '2023-02-18 10:25:15'); INSERT INTO `t_learn` VALUES (10147 10059 10002 11 '2024-03-30 03:20:04'); INSERT INTO `t_learn` VALUES (10148 10001 10002 6 '2024-05-16 09:40:05'); INSERT INTO `t_learn` VALUES (10149 10023 10002 44 '2024-04-21 10:45:41'); INSERT INTO `t_learn` VALUES (10150 10004 10002 3 '2024-08-13 07:19:31'); INSERT INTO `t_learn` VALUES (10151 10025 10003 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10152 10032 10003 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10153 10072 10003 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10154 10010 10003 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10155 10045 10003 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10156 10086 10003 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10157 10050 10003 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10158 10046 10003 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10159 10011 10003 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10160 10055 10003 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10161 10044 10003 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10162 10098 10003 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10163 10040 10003 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10164 10074 10003 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10165 10069 10003 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10166 10067 10003 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10167 10087 10003 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10168 10080 10003 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10169 10093 10003 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10170 10028 10003 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10171 10062 10003 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10172 10049 10003 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10173 10039 10003 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10174 10005 10003 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10175 10065 10003 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10176 10047 10003 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10177 10012 10003 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10178 10037 10003 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10179 10018 10003 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10180 10066 10003 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10181 10063 10003 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10182 10090 10003 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10183 10085 10003 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10184 10092 10003 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10185 10060 10003 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10186 10088 10003 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10187 10071 10003 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10188 10079 10003 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10189 10091 10003 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10190 10003 10003 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10191 10083 10003 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10192 10054 10003 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10193 10017 10003 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10194 10021 10003 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10195 10014 10003 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10196 10051 10003 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10197 10035 10003 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10198 10008 10003 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10199 10100 10003 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10200 10016 10003 33 '2024-07-05 11:07:38'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `id` int(10) NOT NULL AUTO_INCREMENT `name` 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 PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001 '周岚' 'G1WGE2rmBJ' 'BnxWZAnSPk'); INSERT INTO `t_student` VALUES (10002 '石晓明' 'O5UrHL3wAk' 'jXvPgYp6T7'); INSERT INTO `t_student` VALUES (10003 '丁子韬' 'z6scv3YR39' 'Gkj7yea68K'); INSERT INTO `t_student` VALUES (10004 '贾詩涵' 'dDRhbsIFld' '9S5wmKyd8u'); INSERT INTO `t_student` VALUES (10005 '贾震南' 'yp6ONN6mPK' 'rESuH77r0D'); INSERT INTO `t_student` VALUES (10006 '龚杰宏' '6mX9UUocUJ' 'Vbu9vJS9Eo'); INSERT INTO `t_student` VALUES (10007 '金詩涵' 'J7CEMWLje5' '7XYgyIh7xR'); INSERT INTO `t_student` VALUES (10008 '秦子异' 'szo1eVBizJ' 'dY2RfyIb1m'); INSERT INTO `t_student` VALUES (10009 '袁宇宁' 'J5YrjzB2si' 'UAMXTO3rQ6'); INSERT INTO `t_student` VALUES (10010 '姜秀英' '2MU2HeylW4' '1AfW3NhbgN'); INSERT INTO `t_student` VALUES (10011 '汤杰宏' 'MpE4EPWxqG' 'oaNVhDmy7z'); INSERT INTO `t_student` VALUES (10012 '韦安琪' 'Kdmd781EtP' 'KfjEMQxKep'); INSERT INTO `t_student` VALUES (10013 '唐嘉伦' 'V0C7xf6fjc' 'e1r7KJIx8w'); INSERT INTO `t_student` VALUES (10014 '韩詩涵' 'J273ldcncO' '8hcoDqM4G5'); INSERT INTO `t_student` VALUES (10015 '邱睿' '5f2pShjufE' 'ABRfNTK0oD'); INSERT INTO `t_student` VALUES (10016 '田云熙' 'r6GS6H1Y9i' 'QLPFuc1Ymo'); INSERT INTO `t_student` VALUES (10017 '任璐' 'fOEFM89DMY' 'fgm3mOBTRs'); INSERT INTO `t_student` VALUES (10018 '阎嘉伦' 'uf0T82j8vV' 'MVun8E08gr'); INSERT INTO `t_student` VALUES (10019 '杨秀英' '3ZQyavexff' 'tne8w9hwyT'); INSERT INTO `t_student` VALUES (10020 '贺岚' 'MUzeIJ2Zho' '3hTbEiOlcV'); INSERT INTO `t_student` VALUES (10021 '贾安琪' 'hQKvLXLbdr' 'GxmMRZIVTq'); INSERT INTO `t_student` VALUES (10022 '李震南' 'umEYhDRNCg' 'VIttqgl4h2'); INSERT INTO `t_student` VALUES (10023 '张璐' 'MLmnE9XMrj' 'Vo0HRIunBH'); INSERT INTO `t_student` VALUES (10024 '韦震南' 'g9pxVI84lQ' 'J59D4b8VVF'); INSERT INTO `t_student` VALUES (10025 '严睿' 'GxDaQjWmSb' 'liZCUpGHfa'); INSERT INTO `t_student` VALUES (10026 '姜杰宏' 'kygY1DCCEp' 'VEGVJlU6Ra'); INSERT INTO `t_student` VALUES (10027 '尹震南' 'gDvPS0b24b' 'rjzJgMQWTc'); INSERT INTO `t_student` VALUES (10028 '罗璐' 'S0jjEsFNQJ' 'C6stBhYttY'); INSERT INTO `t_student` VALUES (10029 '姚云熙' 'vEr1jpIgKr' 'cyuhQPR8Lh'); INSERT INTO `t_student` VALUES (10030 '黄子异' 'GRCYTc1DWx' 'kTTYbTor84'); INSERT INTO `t_student` VALUES (10031 '何詩涵' 'gk2SUc1U35' 'ZRIAUeMSYs'); INSERT INTO `t_student` VALUES (10032 '宋安琪' '35U0zOXWcV' 'Ab3HmKqiqv'); INSERT INTO `t_student` VALUES (10033 '陶璐' 'BDNIQACb7W' 'qJD4q0lDsh'); INSERT INTO `t_student` VALUES (10034 '顾睿' 'BdjipSZSh3' 'mtRT0VxhFe'); INSERT INTO `t_student` VALUES (10035 '高杰宏' '4IhblDisF7' 'LKKHmwgBXD'); INSERT INTO `t_student` VALUES (10036 '薛詩涵' 'Y8EEoaicyB' 'rCRrqBFJsv'); INSERT INTO `t_student` VALUES (10037 '丁秀英' '9SlsI0PoyD' 'qsxw3ign25'); INSERT INTO `t_student` VALUES (10038 '贾晓明' 'odNONklQs9' 'BiO5UOkdnW'); INSERT INTO `t_student` VALUES (10039 '任嘉伦' 'VHuzfHBoBO' 'lTAovUC389'); INSERT INTO `t_student` VALUES (10040 '胡震南' 'sv46bTnf0P' 'iBzeHjykYx'); INSERT INTO `t_student` VALUES (10041 '萧睿' '0TDvbKZIoK' 'zZ9ZYbUS8y'); INSERT INTO `t_student` VALUES (10042 '于子韬' 'ByZpvehylm' 'tFjQxRfu6v'); INSERT INTO `t_student` VALUES (10043 '吴子韬' 'zgNIgSi0R6' 'NnCXSPGSG9'); INSERT INTO `t_student` VALUES (10044 '袁子异' 'QofuPCZDj2' 'OQKCjRA6KL'); INSERT INTO `t_student` VALUES (10045 '孙岚' 'RX9ReXfnDD' 'iaFxFUs3UR'); INSERT INTO `t_student` VALUES (10046 '袁晓明' '9AnMs8NLT7' 'TBAHhl6HP4'); INSERT INTO `t_student` VALUES (10047 '邹云熙' 'cVTK8Zk23n' 'sHZWvI31eg'); INSERT INTO `t_student` VALUES (10048 '潘震南' 'sl9DcFJ7l0' 'mCKMLEAWnL'); INSERT INTO `t_student` VALUES (10049 '侯安琪' 'y0yHJRlVD0' '8w14vG11Lo'); INSERT INTO `t_student` VALUES (10050 '宋致远' 'mbj6fi5LVJ' 'EvI1OF2mUU'); INSERT INTO `t_student` VALUES (10051 '向杰宏' 'rdTBGDlk1e' 'KLrEH5OIRV'); INSERT INTO `t_student` VALUES (10052 '侯岚' 'vRIL8GezRB' 'BCnlCfMe3i'); INSERT INTO `t_student` VALUES (10053 '郝震南' 'N5OHE7WNRd' 'YSEMSIBoF6'); INSERT INTO `t_student` VALUES (10054 '田晓明' 'JFjgjbtPYw' 'C1GMv8jJI4'); INSERT INTO `t_student` VALUES (10055 '金岚' 'gpRnYYtKUp' 'I7Ha61aFlW'); INSERT INTO `t_student` VALUES (10056 '何晓明' 'mIUWaHvpVT' '0sGahlQonR'); INSERT INTO `t_student` VALUES (10057 '吕睿' 'FfkVgyM5SS' 'ie36JBbaUq'); INSERT INTO `t_student` VALUES (10058 '段岚' 'qZWlkeuZou' 'UxP4bndlVw'); INSERT INTO `t_student` VALUES (10059 '宋詩涵' 'McHsYoxoix' 'QedjPd3cfE'); INSERT INTO `t_student` VALUES (10060 '谢秀英' 'Pw2td9ptEO' 'YCdTBkV5u1'); INSERT INTO `t_student` VALUES (10061 '姚睿' 't4zYkGf3fF' '848evloRxx'); INSERT INTO `t_student` VALUES (10062 '贺安琪' '1RjkUEhkZY' '4f0WkjDBkk'); INSERT INTO `t_student` VALUES (10063 '段嘉伦' 'qPY9LKYuqQ' 'jeBmxO9JHj'); INSERT INTO `t_student` VALUES (10064 '唐震南' 'r6bXO95F2D' 'X3HbgEcK8Y'); INSERT INTO `t_student` VALUES (10065 '谢岚' 'naL2KZrHwA' 'AkqosUcsuV'); INSERT INTO `t_student` VALUES (10066 '杨安琪' 'AX8Deo1g7Q' 'qaF4nJ5WpP'); INSERT INTO `t_student` VALUES (10067 '吴杰宏' 'GMzkfndLZv' 'tVfNr43Awi'); INSERT INTO `t_student` VALUES (10068 '曹晓明' '3MhPP9Ba2T' 'WdLUDxvV4D'); INSERT INTO `t_student` VALUES (10069 '赵杰宏' 'bifOEeXCWu' 'LOYM3jaDT2'); INSERT INTO `t_student` VALUES (10070 '钟安琪' 'RaRkUvlMKo' 'YZvGiLMMPa'); INSERT INTO `t_student` VALUES (10071 '向云熙' 'JLLo5dbzOE' 'dwjwJlsE2J'); INSERT INTO `t_student` VALUES (10072 '雷晓明' 'SzkAnohkjE' 'vEI4b77pR7'); INSERT INTO `t_student` VALUES (10073 '汪云熙' 'Dx0e0UItxA' 'phZtzNxzOq'); INSERT INTO `t_student` VALUES (10074 '杨子异' 'fD9kEW1Sq6' 'zImkNQBSUQ'); INSERT INTO `t_student` VALUES (10075 '郭睿' 'JnzPqdQDt8' 'gEcH8ew4sF'); INSERT INTO `t_student` VALUES (10076 '沈子韬' 'ttt1sSrCzJ' '5ywB4pgDqm'); INSERT INTO `t_student` VALUES (10077 '朱子异' 'XnNaK6Q9gu' 'lVWPPYWbTy'); INSERT INTO `t_student` VALUES (10078 '侯璐' 'FqbUPAxjR1' 'hTWsxzLogn'); INSERT INTO `t_student` VALUES (10079 '许宇宁' 'LkzJ9oO3PV' 'sQ12axSWyz'); INSERT INTO `t_student` VALUES (10080 '高云熙' '89PlIz8Y7B' 'h8VtFDBIgf'); INSERT INTO `t_student` VALUES (10081 '杜安琪' 'EIeSoLwSW3' 'dla1wIhe3w'); INSERT INTO `t_student` VALUES (10082 '冯嘉伦' 'Ot9OQzc5Tf' 'HpucsNAfnU'); INSERT INTO `t_student` VALUES (10083 '彭子韬' 'UkeqT8NtJX' '3fPftOFs96'); INSERT INTO `t_student` VALUES (10084 '史震南' 'C1ONnCOf1a' '2wTfHZYsnV'); INSERT INTO `t_student` VALUES (10085 '尹云熙' 'pPD5hlAxiW' 'R9yAP19RJH'); INSERT INTO `t_student` VALUES (10086 '许震南' 'tHPwJY3CDY' 'kwd4uH98o3'); INSERT INTO `t_student` VALUES (10087 '李安琪' 'K2r0WllYzO' 'kNRVRYv0qr'); INSERT INTO `t_student` VALUES (10088 '林子异' '8Ttbp7gc06' 'lj7SdtOYwS'); INSERT INTO `t_student` VALUES (10089 '严嘉伦' 'PNIs8LHIUr' '7XVizBwqrW'); INSERT INTO `t_student` VALUES (10090 '黎杰宏' 'rmjckwsCP6' 'O7BYlHG8A5'); INSERT INTO `t_student` VALUES (10091 '梁杰宏' 'ya3q3e30R9' 'ZpToh85AMq'); INSERT INTO `t_student` VALUES (10092 '张晓明' 'mkY7T8tpA6' 'PW3j7y3ZQS'); INSERT INTO `t_student` VALUES (10093 '吴致远' 'ba5fmbCSUO' 'MMfkS9Lwr7'); INSERT INTO `t_student` VALUES (10094 '陶詩涵' '7bWA6xXp1A' 'Tlo0LxVlVH'); INSERT INTO `t_student` VALUES (10095 '曹睿' 'N08y7yJu15' '8ue93KnrvI'); INSERT INTO `t_student` VALUES (10096 '方宇宁' 't9xDmfZaEQ' 'Xm9umRA1Uc'); INSERT INTO `t_student` VALUES (10097 '曹安琪' 'vG4ZtAQanT' 'Vth5vsry9y'); INSERT INTO `t_student` VALUES (10098 '杨子异' 'YUf12JCtO6' '8999nWETCU'); INSERT INTO `t_student` VALUES (10099 '于杰宏' 'l3NbjhRoCR' 'qCPLVovMjL'); INSERT INTO `t_student` VALUES (10100 '郑震南' 'G3nVY0YbM8' 'vLRejxC1Ve'); -- ---------------------------- -- Table structure for t_video -- ---------------------------- DROP TABLE IF EXISTS `t_video`; CREATE TABLE `t_video` ( `id` int(10) NOT NULL AUTO_INCREMENT `c_id` int(10) 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 (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10145 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_video -- ---------------------------- INSERT INTO `t_video` VALUES (10001 10001 'Navicat Monitor requires ' 'https://video.nishiminat.com/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10002 10003 'To successfully establish ' 'https://video.kamtl.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10003 10002 'How we spend our days ' 'http://video.kjialun.net/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10004 10003 'To successfully establish ' 'https://video.hyhan56.net/Handcrafts'); INSERT INTO `t_video` VALUES (10005 10002 'If the Show objects under ' 'http://video.shishih.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10006 10003 'Anyone who has ever made ' 'https://video.anme7.com/Books'); INSERT INTO `t_video` VALUES (10007 10002 'To get a secure connection ' 'http://video.manuelell60.info/HealthBabyCare'); INSERT INTO `t_video` VALUES (10008 10002 'To successfully establish ' 'http://video.imi10.us/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10009 10003 'It provides strong authentication ' 'https://video.miutszching.org/Appliances'); INSERT INTO `t_video` VALUES (10010 10001 'There is no way to happiness. ' 'http://video.vasquedwa.biz/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10011 10001 'Import Wizard allows ' 'http://video.stszhin.org/CDsVinyl'); INSERT INTO `t_video` VALUES (10012 10002 'Flexible settings enable ' 'http://video.psarah.us/Others'); INSERT INTO `t_video` VALUES (10013 10001 'To connect to a database ' 'http://video.yamadsara.jp/Food'); INSERT INTO `t_video` VALUES (10014 10002 'If you wait all that ' 'https://video.wfts1.co.jp/ToysGames'); INSERT INTO `t_video` VALUES (10015 10003 'It wasn’t raining when ' 'http://video.cook77.net/ToysGames'); INSERT INTO `t_video` VALUES (10016 10002 'Success consists of going ' 'http://video.zhiyuanding.us/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10017 10003 'In other words Navicat ' 'https://video.waiyeesiu.biz/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10018 10002 'If the Show objects under ' 'http://video.sumwinglok.biz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10019 10001 'I will greet this day ' 'https://video.carol3.net/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10020 10002 'SQL Editor allows you ' 'https://video.kad.xyz/MusicalInstrument'); INSERT INTO `t_video` VALUES (10021 10003 'In the Objects tab you ' 'https://video.luj.org/SportsOutdoor'); INSERT INTO `t_video` VALUES (10022 10003 'It collects process metrics ' 'https://video.laws10.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10023 10001 'Navicat provides powerful ' 'https://video.xiaoming9.net/Appliances'); INSERT INTO `t_video` VALUES (10024 10002 'A man’s best friends ' 'http://video.zhiyuliang8.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10025 10002 'It wasn’t raining when ' 'https://video.hu1942.us/CDsVinyl'); INSERT INTO `t_video` VALUES (10026 10001 'Anyone who has never ' 'https://video.shim.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10027 10001 'The reason why a great ' 'http://video.hazukio.org/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10028 10002 'Creativity is intelligence having fun.' 'http://video.matsudae07.cn/ToysGames'); INSERT INTO `t_video` VALUES (10029 10002 'Optimism is the one quality ' 'https://video.zhenjiang711.jp/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10030 10001 'A query is used to extract ' 'http://video.karyanchoi.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10031 10001 'To successfully establish ' 'http://video.kaming43.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10032 10001 'To successfully establish ' 'http://video.ylu321.net/FilmSupplies'); INSERT INTO `t_video` VALUES (10033 10002 'In other words Navicat ' 'https://video.bt10.info/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10034 10002 'There is no way to happiness. ' 'http://video.hung9.co.jp/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10035 10002 'The first step is as good as half over.' 'https://video.muran.jp/Baby'); INSERT INTO `t_video` VALUES (10036 10001 'All the Navicat Cloud ' 'http://video.gonzalezbru85.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10037 10002 'Navicat 15 has added ' 'https://video.jesusoto.co.jp/Appliances'); INSERT INTO `t_video` VALUES (10038 10001 'It wasn’t raining when ' 'http://video.carant.co.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10039 10002 'If your Internet Service ' 'http://video.edwards1.jp/CDsVinyl'); INSERT INTO `t_video` VALUES (10040 10002 'You must be the change ' 'https://video.zhiyuan2.org/FilmSupplies'); INSERT INTO `t_video` VALUES (10041 10002 'All journeys have secret ' 'https://video.tlwan4.net/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10042 10001 'It wasn’t raining when ' 'http://video.hanzit.xyz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10043 10002 'Import Wizard allows ' 'http://video.willimoore83.net/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10044 10003 'Navicat is a multi-connections ' 'https://video.porter620.cn/ToysGames'); INSERT INTO `t_video` VALUES (10045 10002 'Navicat Data Modeler ' 'http://video.su715.com/Food'); INSERT INTO `t_video` VALUES (10046 10001 'Remember that failure ' 'https://video.watsonapril.jp/FilmSupplies'); INSERT INTO `t_video` VALUES (10047 10003 'Import Wizard allows ' 'http://video.sarahriv10.xyz/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10048 10001 'Navicat Cloud could not ' 'http://video.medw.org/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10049 10002 'It collects process metrics ' 'http://video.okamomo.com/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10050 10003 'Navicat 15 has added ' 'http://video.renaokada.xyz/Others'); INSERT INTO `t_video` VALUES (10051 10003 'The On Startup feature ' 'https://video.rythomas104.info/Beauty'); INSERT INTO `t_video` VALUES (10052 10001 'You will succeed because ' 'http://video.saitoaoshi.co.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10053 10001 'Navicat is a multi-connections ' 'http://video.lzhen.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10054 10003 'If it scares you it ' 'https://video.barnes722.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10055 10002 'HTTP Tunneling is a method ' 'http://video.man1.us/SportsOutdoor'); INSERT INTO `t_video` VALUES (10056 10003 'The On Startup feature ' 'https://video.he506.us/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10057 10001 'Navicat Monitor requires ' 'https://video.myam.info/ToysGames'); INSERT INTO `t_video` VALUES (10058 10003 'Import Wizard allows ' 'https://video.sy7.org/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10059 10002 'Success consists of going ' 'https://video.itsuki521.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10060 10003 'It wasn’t raining when ' 'https://video.hsuankwokkuen1970.org/PetSupplies'); INSERT INTO `t_video` VALUES (10061 10003 'Remember that failure ' 'http://video.cht.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10062 10003 'The Synchronize to Database ' 'https://video.nakayama17.biz/Baby'); INSERT INTO `t_video` VALUES (10063 10003 'There is no way to happiness. ' 'http://video.albjohnson.net/HealthBabyCare'); INSERT INTO `t_video` VALUES (10064 10003 'SQL Editor allows you ' 'http://video.kasumiarai.co.jp/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10065 10001 'Navicat allows you to ' 'https://video.parker621.com/VideoGames'); INSERT INTO `t_video` VALUES (10066 10001 'SQL Editor allows you ' 'http://video.sato1222.co.jp/MusicalInstrument'); INSERT INTO `t_video` VALUES (10067 10003 'Difficult circumstances ' 'http://video.yli614.us/CDsVinyl'); INSERT INTO `t_video` VALUES (10068 10003 'It wasn’t raining when ' 'http://video.miliksun.net/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10069 10003 'In a Telnet session ' 'https://video.debrama.cn/AutomotivePartsAccessories'); INSERT INTO `t_video` VALUES (10070 10001 'If opportunity doesn’t ' 'http://video.eitamatsu.org/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10071 10003 'Typically it is employed ' 'http://video.jamesaguilar.org/Baby'); INSERT INTO `t_video` VALUES (10072 10002 'I will greet this day ' 'https://video.aokimis.com/Baby'); INSERT INTO `t_video` VALUES (10073 10002 'The repository database ' 'https://video.kasumiwa2003.cn/ToysGames'); INSERT INTO `t_video` VALUES (10074 10001 'In the middle of winter ' 'https://video.phillipsj.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10075 10001 'Difficult circumstances ' 'https://video.lli627.jp/SportsOutdoor'); INSERT INTO `t_video` VALUES (10076 10001 'It wasn’t raining when ' 'http://video.nanaminishimura7.xyz/Handcrafts'); INSERT INTO `t_video` VALUES (10077 10001 'A query is used to extract ' 'http://video.hasegak925.us/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10078 10003 'The Information Pane ' 'http://video.takasumi.jp/FilmSupplies'); INSERT INTO `t_video` VALUES (10079 10003 'Always keep your eyes ' 'https://video.huimeicho75.info/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10080 10002 'In the Objects tab you ' 'https://video.ashley66.com/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10081 10002 'You must be the change ' 'http://video.anqiwe.info/CDsVinyl'); INSERT INTO `t_video` VALUES (10082 10003 'A man is not old until ' 'http://video.miuraitsuki.xyz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10083 10002 'In the middle of winter ' 'http://video.sad.biz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10084 10003 'Navicat Monitor can be ' 'http://video.sm513.xyz/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10085 10001 'Flexible settings enable ' 'http://video.rihi.xyz/PetSupplies'); INSERT INTO `t_video` VALUES (10086 10003 'It provides strong authentication ' 'https://video.weddie.biz/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10087 10002 'It provides strong authentication ' 'http://video.tsand.com/Baby'); INSERT INTO `t_video` VALUES (10088 10001 'In the middle of winter ' 'http://video.matsusakura.org/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10089 10002 'Instead of wondering ' 'http://video.ayato129.com/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10090 10002 'In a Telnet session ' 'https://video.ngliksun44.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10091 10001 'In the middle of winter ' 'https://video.lanf80.cn/Books'); INSERT INTO `t_video` VALUES (10092 10003 'Genius is an infinite ' 'http://video.wp9.co.jp/Baby'); INSERT INTO `t_video` VALUES (10093 10003 'A man’s best friends ' 'https://video.tangcm1956.net/AppsGames'); INSERT INTO `t_video` VALUES (10094 10003 'Navicat provides powerful ' 'http://video.mingyung2018.com/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10095 10002 'Monitored servers include ' 'https://video.wl01.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10096 10001 'Secure SHell (SSH) is ' 'https://video.yu713.info/PetSupplies'); INSERT INTO `t_video` VALUES (10097 10002 'Navicat Monitor requires ' 'https://video.fongchiming901.biz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10098 10002 'In other words Navicat ' 'https://video.jose17.co.jp/Food'); INSERT INTO `t_video` VALUES (10099 10003 'A comfort zone is a beautiful ' 'https://video.xiayuni.biz/FilmSupplies'); INSERT INTO `t_video` VALUES (10100 10001 'There is no way to happiness. ' 'http://video.mo1997.xyz/Beauty'); INSERT INTO `t_video` VALUES (10101 10001 'SSH serves to prevent ' 'http://video.lsha6.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10102 10003 'It can also manage cloud ' 'http://video.txiuy51.jp/Beauty'); INSERT INTO `t_video` VALUES (10103 10003 'If you wait all that ' 'http://video.arthurmo.biz/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10104 10001 'The first step is as good as half over.' 'http://video.kwokyin306.org/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10105 10003 'Remember that failure ' 'http://video.qiuzit4.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10106 10002 'Navicat Monitor requires ' 'http://video.ricet.jp/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10107 10002 'To open a query using ' 'https://video.hashino.us/Others'); INSERT INTO `t_video` VALUES (10108 10003 'The Synchronize to Database ' 'http://video.nelsondavid10.xyz/ToysGames'); INSERT INTO `t_video` VALUES (10109 10003 'Genius is an infinite ' 'https://video.lauwl1958.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10110 10002 'Navicat Monitor is a ' 'https://video.jia915.co.jp/HealthBabyCare'); INSERT INTO `t_video` VALUES (10111 10003 'The first step is as good as half over.' 'https://video.sanakayama.xyz/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10112 10001 'Export Wizard allows ' 'https://video.watam.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10113 10001 'Remember that failure ' 'http://video.ntsub.biz/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10114 10001 'Secure Sockets Layer(SSL) ' 'http://video.tsubas.us/FilmSupplies'); INSERT INTO `t_video` VALUES (10115 10001 'You will succeed because ' 'https://video.moralrub.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10116 10001 'If you wait all that ' 'http://video.kathreynolds.biz/Appliances'); INSERT INTO `t_video` VALUES (10117 10003 'If the Show objects under ' 'https://video.rche.us/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10118 10002 'After logged in the Navicat ' 'http://video.sefukud3.biz/CDsVinyl'); INSERT INTO `t_video` VALUES (10119 10002 'The reason why a great ' 'https://video.yinchiehlun.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10120 10001 'A query is used to extract ' 'http://video.jialungu.xyz/CDsVinyl'); INSERT INTO `t_video` VALUES (10121 10001 'To clear or reload various ' 'http://video.soto5.cn/SportsOutdoor'); INSERT INTO `t_video` VALUES (10122 10001 'How we spend our days ' 'http://video.shingkm.xyz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10123 10001 'A man is not old until ' 'https://video.karenbryant.com/ToysGames'); INSERT INTO `t_video` VALUES (10124 10001 'You will succeed because ' 'http://video.yanshih4.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10125 10003 'SQL Editor allows you ' 'http://video.fskwok4.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10126 10002 'To open a query using ' 'https://video.chenrich.cn/VideoGames'); INSERT INTO `t_video` VALUES (10127 10003 'Always keep your eyes ' 'http://video.hyliao6.cn/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10128 10003 'You will succeed because ' 'https://video.mao45.org/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10129 10001 'I may not have gone where ' 'http://video.oghikari.net/Books'); INSERT INTO `t_video` VALUES (10130 10003 'It provides strong authentication ' 'https://video.onhaz2.org/VideoGames'); INSERT INTO `t_video` VALUES (10131 10003 'Success consists of going ' 'http://video.rikuwa.info/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10132 10002 'The repository database ' 'https://video.yuna9.info/AutomotivePartsAccessories'); INSERT INTO `t_video` VALUES (10133 10002 'All the Navicat Cloud ' 'https://video.johnngar.com/Beauty'); INSERT INTO `t_video` VALUES (10134 10001 'Export Wizard allows ' 'http://video.zyuan.com/HealthBabyCare'); INSERT INTO `t_video` VALUES (10135 10003 'The Information Pane ' 'https://video.xuerui9.biz/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10136 10003 'The Main Window consists ' 'https://video.ruixu.xyz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10137 10001 'In the middle of winter ' 'https://video.wstang.co.jp/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10138 10003 'If the plan doesn’t ' 'https://video.mc93.us/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10139 10002 'It can also manage cloud ' 'https://video.ntingfung.info/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10140 10001 'If the Show objects under ' 'http://video.myunxi43.info/Handcrafts'); INSERT INTO `t_video` VALUES (10141 10001 'If it scares you it ' 'http://video.endh54.xyz/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10142 10002 'The Information Pane ' 'http://video.takwahmok9.us/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10143 10002 'To connect to a database ' 'http://video.miuramomoe.cn/Appliances'); INSERT INTO `t_video` VALUES (10144 10002 'Navicat is a multi-connections ' 'http://video.lishiha.net/Appliances'); SET FOREIGN_KEY_CHECKS = 1; $ 《MySQL数据库基础》 期末复习卷(四) 时间:90分钟 总分:100分 班级 姓名 学号 成绩 一.数据库操作题(本大题共5小题,每小题20分,共100分) 1.舞蹈课程管理系统数据库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_clsss包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式) 1).t_teacher表中添加entry_date(入职日期)字段,类型为 date,默认为 2024-01-01 2).添加一条老师数据,id:10033,name:赵雅芝,sex:女,age:32,tel:15912345678,entry_date:2023-06-15 3).使用SQL语句查询年龄大于 25 岁的男学员和女学员人数,要求显示字段:性别、人数(该字段名称显示为count) 4).使用SQL语句查询周三和周五上课的学生信息 5).使用SQL语句查询带班数量超过 2 个班级的老师信息 6).查询没有被任何学生选择的课程信息,显示字段:课程名称、课时 7).创建视图名称为 v_teacher_course,要求显示老师代班信息,显示字段名为:老师姓名、班级名称、课程名称、上课时间 2.医疗管理数据库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).创建一个药品表,名称为 tb_medicine,字段如下: mid(药品编号) char(10) 主键 mname(药品名称)varchar(50) 不能为空 price(单价)decimal(8,2) stock(库存量)int 默认 0 expiry_date(有效期)date 2).往tb_medicine表中添加一条数据,药品编号为 m0020,药品名称为阿莫西林,单价为28.50,库存量为200,有效期为2025-12-31 3).tb_doctor表中修改tel联系电话字段类型为varchar,长度为15 4).tb_patient表中将患者编号为p0005的患者姓名修改为张明伟 5).用SQL语句查询职称不是主任也不是实习的医生信息 6).用SQL语句添加一条挂号信息,挂号编号为r0100,患者编号为p0010,医生编号为d0025,挂号日期为2024-09-15 7).创建视图名称为v_patient_visit,要求显示患者就诊记录,显示字段:患者姓名、医生姓名、科室、挂号日期 3.舞蹈课程管理系统数据库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_clsss包含字段id(班级编号),name(班级名称),tea_id(老师编号),cou_id(课程编号),time(上课时间) t_teacher包含字段id(老师编号),name(老师姓名),sex(性别),age(年龄),tel(联系方式),salary(薪资) 1).t_student表中id设置为主键,自动增长(起始值为 1000) 2).添加一条学员数据,学员姓名为林小美,性别为女,年龄为22,联系方式为18612345678,班级编号为 2 3).使用SQL语句查询t_student中年龄最小的 3 个学员信息 4).修改t_class表中周一班的班级名称从周一基础班修改为周一强化班 5).使用 SQL 语句查询每个老师所带班级的数量,查询结果按照老师编号分组显示,要求显示字段名为:老师编号、老师姓名、带班数量 6).使用 SQL 语句查询学员 张小凡 所学的课程名称和上课时间 7).创建视图名称为 v_student_info,要求显示学员详细信息,显示字段名为:学员姓名、班级名称、课程名称、老师姓名、上课时间 4.线上教育数据库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).t_student表添加字段email(邮箱)类型varchar(50),默认为暂无 2).添加一个新的学生,学生姓名为欧阳静,用户名为ouyangjing,密码为123456,邮箱为ouyang@126.com 3).用SQL语句查询t_video表信息,按照课程编号正序排列 4).用SQL语句查询每个学生学习的课程数量,查询结果按照学生姓名进行分组显示,要求显示字段名为:学生姓名、学习课程数量 5).用SQL语句查询学习进度低于30%的学生课程学习记录,显示学生姓名、课程名称、学习进度 6).用SQL语句查询学生周子衡未完成的课程(学习进度小于 100%),要求显示字段名为:学生姓名、课程名称、学习进度 7).创建视图名称为 v_course_video,显示课程视频信息,要求显示字段名称为:课程名称、视频标题、视频链接 5.人力资源管理系统数据库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).创建一个考勤表,名称为 t_attendance,字段如下: id(考勤编号) int(8) 主键 e_id(员工编号) int(8) 不能为空 att_date(考勤日期) date status(考勤状态)varchar(20) 默认为 正常 remark(备注)varchar(100) 2).添加部门信息,部门编号为10010,部门名称为技术研发部,部门描述为负责公司技术研发工作 3).删除员工编号为10030的员工信息(同时考虑外键约束) 4).将销售部的部门描述修改为负责公司产品销售和市场拓展 5).用SQL语句查询薪资低于4000或者高于10000的薪资信息,显示员工姓名、薪资、薪资日期 6).用SQL语句查询每个职位的平均薪资,分别用列名:职位名称、平均薪资,查询结果按照职位分组显示 7).创建视图名称为v_employee_salary,要求显示员工薪资信息,分别用列名:部门名称、员工姓名、职位、薪资、薪资日期,结果按照薪资从高到低排序 8).创建一个名称为check_salary_before_insert的触发器,用来自动校验薪资数据,具体描述如下:当向t_salary表中添加新薪资记录时,这个触发器检查薪资金额是否小于0,如果小于0则自动设置为0 9).创建一个名称为get_employee_count_by_dept的存储过程统计部门人数,具体描述如下:这个存储过程接收一个部门 ID(dept_id)作为输入参数,数据类型为int,并统计该部门下的员工人数,然后通过输出参数(emp_count)返回这个值,返回值为int类型 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题一/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; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题三/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: 08/01/2024 14:41:46 */ 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) NULL DEFAULT NULL, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `period` int(5) 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, '街舞', 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, `salary` decimal(6, 2) NULL DEFAULT 5000.00, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10012 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_teacher -- ---------------------------- INSERT INTO `t_teacher` VALUES (10001, '毛岚', '女', 32, '141-2488-8388', 5500.00); INSERT INTO `t_teacher` VALUES (10002, '阎璐', '女', 31, '755-797-4098', 6000.00); INSERT INTO `t_teacher` VALUES (10003, '徐宇宁', '男', 26, '156-9777-4532', 5200.00); INSERT INTO `t_teacher` VALUES (10004, '罗云熙', '男', 35, '168-2861-0381', 8000.00); INSERT INTO `t_teacher` VALUES (10005, '郑岚', '女', 26, '755-117-8789', 5000.00); INSERT INTO `t_teacher` VALUES (10006, '韩杰宏', '男', 34, '755-801-7051', 8200.00); INSERT INTO `t_teacher` VALUES (10007, '谢子异', '男', 30, '755-286-0780', 7100.00); INSERT INTO `t_teacher` VALUES (10008, '侯睿', '男', 28, '135-3705-3061', 6800.00); INSERT INTO `t_teacher` VALUES (10009, '林岚', '女', 31, '147-4778-0303', 7500.00); INSERT INTO `t_teacher` VALUES (10010, '钱杰宏', '男', 26, '165-0043-6486', 5000.00); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题二/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'); -- ---------------------------- -- Table structure for tb_patient -- ---------------------------- DROP TABLE IF EXISTS `tb_patient`; CREATE TABLE `tb_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` char(10) 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 (`pid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_patient -- ---------------------------- INSERT INTO `tb_patient` VALUES ('p0001', '刘云', '女', '16', '111111111'); INSERT INTO `tb_patient` VALUES ('p0002', '赵华', '男', '31', '222222222'); INSERT INTO `tb_patient` VALUES ('p0003', '王强', '男', '22', '333333333'); INSERT INTO `tb_patient` VALUES ('p0004', '马汉', '男', '33', '444444444'); INSERT INTO `tb_patient` VALUES ('p0005', '方燕', '女', '21', '55555555'); INSERT INTO `tb_patient` VALUES ('p0006', '王小丽', '女', '55', '66666666'); INSERT INTO `tb_patient` VALUES ('p0007', '陈大强', '男', '77', '77777777'); -- ---------------------------- -- Table structure for tb_registration -- ---------------------------- DROP TABLE IF EXISTS `tb_registration`; CREATE TABLE `tb_registration` ( `rid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `did` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rtime` date NULL DEFAULT NULL, PRIMARY KEY (`rid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_registration -- ---------------------------- INSERT INTO `tb_registration` VALUES ('r0001', 'p0001', 'd0001', '2023-10-30'); INSERT INTO `tb_registration` VALUES ('r0002', 'p0002', 'd0006', '2023-11-01'); INSERT INTO `tb_registration` VALUES ('r0003', 'p0003', 'd0002', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0004', 'p0004', 'd0005', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0005', 'p0005', 'd0004', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0006', 'p0006', 'd0003', '2023-11-02'); INSERT INTO `tb_registration` VALUES ('r0007', 'p0007', 'd0006', '2023-11-02'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题五/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'); 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（四）（素材）/题四/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: 16/01/2024 15:44:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 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 NOT NULL `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `period` int(10) NULL DEFAULT NULL PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10004 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); -- ---------------------------- -- Table structure for t_learn -- ---------------------------- DROP TABLE IF EXISTS `t_learn`; CREATE TABLE `t_learn` ( `id` int(10) NOT NULL AUTO_INCREMENT `s_id` int(10) NOT NULL `c_id` int(10) NOT NULL `schedule` int(11) NULL DEFAULT 0 `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10201 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_learn -- ---------------------------- INSERT INTO `t_learn` VALUES (10001 10025 10001 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10002 10032 10001 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10003 10072 10001 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10004 10010 10001 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10005 10045 10001 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10006 10086 10001 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10007 10050 10001 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10008 10046 10001 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10009 10011 10001 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10010 10055 10001 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10011 10044 10001 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10012 10098 10001 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10013 10040 10001 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10014 10074 10001 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10015 10069 10001 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10016 10067 10001 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10017 10087 10001 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10018 10080 10001 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10019 10093 10001 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10020 10028 10001 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10021 10062 10001 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10022 10049 10001 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10023 10039 10001 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10024 10005 10001 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10025 10065 10001 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10026 10047 10001 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10027 10012 10001 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10028 10037 10001 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10029 10018 10001 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10030 10066 10001 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10031 10063 10001 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10032 10090 10001 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10033 10085 10001 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10034 10092 10001 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10035 10060 10001 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10036 10088 10001 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10037 10071 10001 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10038 10079 10001 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10039 10091 10001 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10040 10003 10001 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10041 10083 10001 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10042 10054 10001 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10043 10017 10001 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10044 10021 10001 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10045 10014 10001 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10046 10051 10001 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10047 10035 10001 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10048 10008 10001 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10049 10100 10001 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10050 10016 10001 33 '2024-07-05 11:07:38'); INSERT INTO `t_learn` VALUES (10051 10033 10001 9 '2024-06-27 11:06:15'); INSERT INTO `t_learn` VALUES (10052 10022 10001 15 '2023-11-29 06:00:37'); INSERT INTO `t_learn` VALUES (10053 10082 10001 41 '2024-05-10 13:59:37'); INSERT INTO `t_learn` VALUES (10054 10096 10001 11 '2023-02-27 13:35:38'); INSERT INTO `t_learn` VALUES (10055 10030 10001 27 '2023-01-08 00:29:21'); INSERT INTO `t_learn` VALUES (10056 10029 10001 24 '2024-03-01 05:48:04'); INSERT INTO `t_learn` VALUES (10057 10075 10001 21 '2024-11-09 23:10:32'); INSERT INTO `t_learn` VALUES (10058 10053 10001 1 '2024-10-28 14:38:52'); INSERT INTO `t_learn` VALUES (10059 10041 10001 21 '2024-11-04 06:31:31'); INSERT INTO `t_learn` VALUES (10060 10027 10001 14 '2024-08-30 16:31:07'); INSERT INTO `t_learn` VALUES (10061 10031 10001 30 '2023-05-27 05:01:32'); INSERT INTO `t_learn` VALUES (10062 10052 10001 17 '2024-10-28 01:47:09'); INSERT INTO `t_learn` VALUES (10063 10026 10001 30 '2023-07-09 12:57:40'); INSERT INTO `t_learn` VALUES (10064 10089 10001 15 '2023-10-01 05:36:14'); INSERT INTO `t_learn` VALUES (10065 10043 10001 42 '2024-12-09 18:42:26'); INSERT INTO `t_learn` VALUES (10066 10070 10001 11 '2023-02-18 10:25:15'); INSERT INTO `t_learn` VALUES (10067 10059 10001 11 '2024-03-30 03:20:04'); INSERT INTO `t_learn` VALUES (10068 10001 10001 6 '2024-05-16 09:40:05'); INSERT INTO `t_learn` VALUES (10069 10023 10001 44 '2024-04-21 10:45:41'); INSERT INTO `t_learn` VALUES (10070 10004 10001 3 '2024-08-13 07:19:31'); INSERT INTO `t_learn` VALUES (10071 10076 10001 39 '2024-10-25 10:09:28'); INSERT INTO `t_learn` VALUES (10072 10056 10001 37 '2023-09-01 08:05:29'); INSERT INTO `t_learn` VALUES (10073 10019 10001 40 '2024-06-21 07:31:46'); INSERT INTO `t_learn` VALUES (10074 10002 10001 38 '2023-03-14 18:31:13'); INSERT INTO `t_learn` VALUES (10075 10064 10001 23 '2024-04-01 22:39:29'); INSERT INTO `t_learn` VALUES (10076 10036 10001 44 '2023-08-09 04:24:49'); INSERT INTO `t_learn` VALUES (10077 10078 10001 40 '2024-10-08 05:24:30'); INSERT INTO `t_learn` VALUES (10078 10081 10001 21 '2024-04-09 13:56:25'); INSERT INTO `t_learn` VALUES (10079 10084 10001 39 '2023-08-29 11:57:20'); INSERT INTO `t_learn` VALUES (10080 10038 10001 15 '2024-10-02 13:21:22'); INSERT INTO `t_learn` VALUES (10081 10025 10002 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10082 10032 10002 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10083 10072 10002 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10084 10010 10002 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10085 10045 10002 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10086 10086 10002 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10087 10050 10002 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10088 10046 10002 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10089 10011 10002 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10090 10055 10002 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10091 10044 10002 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10092 10098 10002 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10093 10040 10002 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10094 10074 10002 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10095 10069 10002 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10096 10067 10002 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10097 10087 10002 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10098 10080 10002 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10099 10093 10002 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10100 10028 10002 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10101 10062 10002 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10102 10049 10002 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10103 10039 10002 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10104 10005 10002 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10105 10065 10002 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10106 10047 10002 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10107 10012 10002 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10108 10037 10002 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10109 10018 10002 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10110 10066 10002 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10111 10063 10002 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10112 10090 10002 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10113 10085 10002 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10114 10092 10002 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10115 10060 10002 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10116 10088 10002 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10117 10071 10002 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10118 10079 10002 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10119 10091 10002 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10120 10003 10002 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10121 10083 10002 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10122 10054 10002 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10123 10017 10002 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10124 10021 10002 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10125 10014 10002 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10126 10051 10002 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10127 10035 10002 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10128 10008 10002 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10129 10100 10002 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10130 10016 10002 33 '2024-07-05 11:07:38'); INSERT INTO `t_learn` VALUES (10131 10033 10002 9 '2024-06-27 11:06:15'); INSERT INTO `t_learn` VALUES (10132 10022 10002 15 '2023-11-29 06:00:37'); INSERT INTO `t_learn` VALUES (10133 10082 10002 41 '2024-05-10 13:59:37'); INSERT INTO `t_learn` VALUES (10134 10096 10002 11 '2023-02-27 13:35:38'); INSERT INTO `t_learn` VALUES (10135 10030 10002 27 '2023-01-08 00:29:21'); INSERT INTO `t_learn` VALUES (10136 10029 10002 24 '2024-03-01 05:48:04'); INSERT INTO `t_learn` VALUES (10137 10075 10002 21 '2024-11-09 23:10:32'); INSERT INTO `t_learn` VALUES (10138 10053 10002 1 '2024-10-28 14:38:52'); INSERT INTO `t_learn` VALUES (10139 10041 10002 21 '2024-11-04 06:31:31'); INSERT INTO `t_learn` VALUES (10140 10027 10002 14 '2024-08-30 16:31:07'); INSERT INTO `t_learn` VALUES (10141 10031 10002 30 '2023-05-27 05:01:32'); INSERT INTO `t_learn` VALUES (10142 10052 10002 17 '2024-10-28 01:47:09'); INSERT INTO `t_learn` VALUES (10143 10026 10002 30 '2023-07-09 12:57:40'); INSERT INTO `t_learn` VALUES (10144 10089 10002 15 '2023-10-01 05:36:14'); INSERT INTO `t_learn` VALUES (10145 10043 10002 42 '2024-12-09 18:42:26'); INSERT INTO `t_learn` VALUES (10146 10070 10002 11 '2023-02-18 10:25:15'); INSERT INTO `t_learn` VALUES (10147 10059 10002 11 '2024-03-30 03:20:04'); INSERT INTO `t_learn` VALUES (10148 10001 10002 6 '2024-05-16 09:40:05'); INSERT INTO `t_learn` VALUES (10149 10023 10002 44 '2024-04-21 10:45:41'); INSERT INTO `t_learn` VALUES (10150 10004 10002 3 '2024-08-13 07:19:31'); INSERT INTO `t_learn` VALUES (10151 10025 10003 17 '2024-05-17 11:38:34'); INSERT INTO `t_learn` VALUES (10152 10032 10003 36 '2024-01-30 10:55:51'); INSERT INTO `t_learn` VALUES (10153 10072 10003 44 '2024-09-12 09:41:22'); INSERT INTO `t_learn` VALUES (10154 10010 10003 8 '2023-03-23 03:19:04'); INSERT INTO `t_learn` VALUES (10155 10045 10003 46 '2023-08-03 01:06:54'); INSERT INTO `t_learn` VALUES (10156 10086 10003 42 '2023-11-23 08:05:33'); INSERT INTO `t_learn` VALUES (10157 10050 10003 3 '2024-10-27 22:15:01'); INSERT INTO `t_learn` VALUES (10158 10046 10003 13 '2024-04-03 07:26:53'); INSERT INTO `t_learn` VALUES (10159 10011 10003 31 '2023-09-28 20:42:04'); INSERT INTO `t_learn` VALUES (10160 10055 10003 20 '2024-02-03 04:12:27'); INSERT INTO `t_learn` VALUES (10161 10044 10003 15 '2023-10-05 10:23:35'); INSERT INTO `t_learn` VALUES (10162 10098 10003 35 '2023-05-19 22:15:18'); INSERT INTO `t_learn` VALUES (10163 10040 10003 25 '2024-03-04 10:10:18'); INSERT INTO `t_learn` VALUES (10164 10074 10003 14 '2024-03-12 11:24:43'); INSERT INTO `t_learn` VALUES (10165 10069 10003 11 '2023-01-28 02:34:49'); INSERT INTO `t_learn` VALUES (10166 10067 10003 11 '2024-04-29 22:19:43'); INSERT INTO `t_learn` VALUES (10167 10087 10003 15 '2023-08-29 06:34:45'); INSERT INTO `t_learn` VALUES (10168 10080 10003 24 '2024-11-11 00:58:52'); INSERT INTO `t_learn` VALUES (10169 10093 10003 43 '2023-05-12 18:41:48'); INSERT INTO `t_learn` VALUES (10170 10028 10003 35 '2023-05-17 17:04:32'); INSERT INTO `t_learn` VALUES (10171 10062 10003 11 '2023-01-29 18:14:58'); INSERT INTO `t_learn` VALUES (10172 10049 10003 34 '2024-09-25 10:38:12'); INSERT INTO `t_learn` VALUES (10173 10039 10003 22 '2024-02-15 18:52:15'); INSERT INTO `t_learn` VALUES (10174 10005 10003 29 '2023-04-25 08:55:57'); INSERT INTO `t_learn` VALUES (10175 10065 10003 20 '2024-10-30 11:22:37'); INSERT INTO `t_learn` VALUES (10176 10047 10003 22 '2023-09-07 21:46:19'); INSERT INTO `t_learn` VALUES (10177 10012 10003 10 '2023-10-10 23:42:06'); INSERT INTO `t_learn` VALUES (10178 10037 10003 5 '2024-03-09 23:35:22'); INSERT INTO `t_learn` VALUES (10179 10018 10003 1 '2024-11-24 06:32:13'); INSERT INTO `t_learn` VALUES (10180 10066 10003 27 '2023-12-01 18:53:00'); INSERT INTO `t_learn` VALUES (10181 10063 10003 28 '2023-06-25 02:55:53'); INSERT INTO `t_learn` VALUES (10182 10090 10003 47 '2024-04-21 14:00:37'); INSERT INTO `t_learn` VALUES (10183 10085 10003 33 '2023-03-22 05:46:52'); INSERT INTO `t_learn` VALUES (10184 10092 10003 5 '2024-04-13 02:36:54'); INSERT INTO `t_learn` VALUES (10185 10060 10003 12 '2023-01-16 11:50:07'); INSERT INTO `t_learn` VALUES (10186 10088 10003 7 '2023-10-17 01:08:32'); INSERT INTO `t_learn` VALUES (10187 10071 10003 36 '2023-10-10 22:28:02'); INSERT INTO `t_learn` VALUES (10188 10079 10003 33 '2024-08-31 07:01:33'); INSERT INTO `t_learn` VALUES (10189 10091 10003 6 '2024-12-08 01:13:17'); INSERT INTO `t_learn` VALUES (10190 10003 10003 2 '2023-02-18 11:46:20'); INSERT INTO `t_learn` VALUES (10191 10083 10003 26 '2023-06-28 14:08:02'); INSERT INTO `t_learn` VALUES (10192 10054 10003 43 '2023-09-14 12:57:41'); INSERT INTO `t_learn` VALUES (10193 10017 10003 27 '2024-04-29 04:22:03'); INSERT INTO `t_learn` VALUES (10194 10021 10003 43 '2023-09-11 09:03:59'); INSERT INTO `t_learn` VALUES (10195 10014 10003 31 '2024-06-28 11:20:58'); INSERT INTO `t_learn` VALUES (10196 10051 10003 24 '2023-06-19 05:29:25'); INSERT INTO `t_learn` VALUES (10197 10035 10003 17 '2024-02-06 00:48:21'); INSERT INTO `t_learn` VALUES (10198 10008 10003 29 '2023-12-28 10:32:43'); INSERT INTO `t_learn` VALUES (10199 10100 10003 19 '2023-07-23 18:51:30'); INSERT INTO `t_learn` VALUES (10200 10016 10003 33 '2024-07-05 11:07:38'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `id` int(10) NOT NULL AUTO_INCREMENT `name` 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 PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001 '周岚' 'G1WGE2rmBJ' 'BnxWZAnSPk'); INSERT INTO `t_student` VALUES (10002 '石晓明' 'O5UrHL3wAk' 'jXvPgYp6T7'); INSERT INTO `t_student` VALUES (10003 '丁子韬' 'z6scv3YR39' 'Gkj7yea68K'); INSERT INTO `t_student` VALUES (10004 '贾詩涵' 'dDRhbsIFld' '9S5wmKyd8u'); INSERT INTO `t_student` VALUES (10005 '贾震南' 'yp6ONN6mPK' 'rESuH77r0D'); INSERT INTO `t_student` VALUES (10006 '龚杰宏' '6mX9UUocUJ' 'Vbu9vJS9Eo'); INSERT INTO `t_student` VALUES (10007 '金詩涵' 'J7CEMWLje5' '7XYgyIh7xR'); INSERT INTO `t_student` VALUES (10008 '秦子异' 'szo1eVBizJ' 'dY2RfyIb1m'); INSERT INTO `t_student` VALUES (10009 '袁宇宁' 'J5YrjzB2si' 'UAMXTO3rQ6'); INSERT INTO `t_student` VALUES (10010 '姜秀英' '2MU2HeylW4' '1AfW3NhbgN'); INSERT INTO `t_student` VALUES (10011 '汤杰宏' 'MpE4EPWxqG' 'oaNVhDmy7z'); INSERT INTO `t_student` VALUES (10012 '韦安琪' 'Kdmd781EtP' 'KfjEMQxKep'); INSERT INTO `t_student` VALUES (10013 '唐嘉伦' 'V0C7xf6fjc' 'e1r7KJIx8w'); INSERT INTO `t_student` VALUES (10014 '韩詩涵' 'J273ldcncO' '8hcoDqM4G5'); INSERT INTO `t_student` VALUES (10015 '邱睿' '5f2pShjufE' 'ABRfNTK0oD'); INSERT INTO `t_student` VALUES (10016 '田云熙' 'r6GS6H1Y9i' 'QLPFuc1Ymo'); INSERT INTO `t_student` VALUES (10017 '任璐' 'fOEFM89DMY' 'fgm3mOBTRs'); INSERT INTO `t_student` VALUES (10018 '阎嘉伦' 'uf0T82j8vV' 'MVun8E08gr'); INSERT INTO `t_student` VALUES (10019 '杨秀英' '3ZQyavexff' 'tne8w9hwyT'); INSERT INTO `t_student` VALUES (10020 '贺岚' 'MUzeIJ2Zho' '3hTbEiOlcV'); INSERT INTO `t_student` VALUES (10021 '贾安琪' 'hQKvLXLbdr' 'GxmMRZIVTq'); INSERT INTO `t_student` VALUES (10022 '李震南' 'umEYhDRNCg' 'VIttqgl4h2'); INSERT INTO `t_student` VALUES (10023 '张璐' 'MLmnE9XMrj' 'Vo0HRIunBH'); INSERT INTO `t_student` VALUES (10024 '韦震南' 'g9pxVI84lQ' 'J59D4b8VVF'); INSERT INTO `t_student` VALUES (10025 '严睿' 'GxDaQjWmSb' 'liZCUpGHfa'); INSERT INTO `t_student` VALUES (10026 '姜杰宏' 'kygY1DCCEp' 'VEGVJlU6Ra'); INSERT INTO `t_student` VALUES (10027 '尹震南' 'gDvPS0b24b' 'rjzJgMQWTc'); INSERT INTO `t_student` VALUES (10028 '罗璐' 'S0jjEsFNQJ' 'C6stBhYttY'); INSERT INTO `t_student` VALUES (10029 '姚云熙' 'vEr1jpIgKr' 'cyuhQPR8Lh'); INSERT INTO `t_student` VALUES (10030 '黄子异' 'GRCYTc1DWx' 'kTTYbTor84'); INSERT INTO `t_student` VALUES (10031 '何詩涵' 'gk2SUc1U35' 'ZRIAUeMSYs'); INSERT INTO `t_student` VALUES (10032 '宋安琪' '35U0zOXWcV' 'Ab3HmKqiqv'); INSERT INTO `t_student` VALUES (10033 '陶璐' 'BDNIQACb7W' 'qJD4q0lDsh'); INSERT INTO `t_student` VALUES (10034 '顾睿' 'BdjipSZSh3' 'mtRT0VxhFe'); INSERT INTO `t_student` VALUES (10035 '高杰宏' '4IhblDisF7' 'LKKHmwgBXD'); INSERT INTO `t_student` VALUES (10036 '薛詩涵' 'Y8EEoaicyB' 'rCRrqBFJsv'); INSERT INTO `t_student` VALUES (10037 '丁秀英' '9SlsI0PoyD' 'qsxw3ign25'); INSERT INTO `t_student` VALUES (10038 '贾晓明' 'odNONklQs9' 'BiO5UOkdnW'); INSERT INTO `t_student` VALUES (10039 '任嘉伦' 'VHuzfHBoBO' 'lTAovUC389'); INSERT INTO `t_student` VALUES (10040 '胡震南' 'sv46bTnf0P' 'iBzeHjykYx'); INSERT INTO `t_student` VALUES (10041 '萧睿' '0TDvbKZIoK' 'zZ9ZYbUS8y'); INSERT INTO `t_student` VALUES (10042 '于子韬' 'ByZpvehylm' 'tFjQxRfu6v'); INSERT INTO `t_student` VALUES (10043 '吴子韬' 'zgNIgSi0R6' 'NnCXSPGSG9'); INSERT INTO `t_student` VALUES (10044 '袁子异' 'QofuPCZDj2' 'OQKCjRA6KL'); INSERT INTO `t_student` VALUES (10045 '孙岚' 'RX9ReXfnDD' 'iaFxFUs3UR'); INSERT INTO `t_student` VALUES (10046 '袁晓明' '9AnMs8NLT7' 'TBAHhl6HP4'); INSERT INTO `t_student` VALUES (10047 '邹云熙' 'cVTK8Zk23n' 'sHZWvI31eg'); INSERT INTO `t_student` VALUES (10048 '潘震南' 'sl9DcFJ7l0' 'mCKMLEAWnL'); INSERT INTO `t_student` VALUES (10049 '侯安琪' 'y0yHJRlVD0' '8w14vG11Lo'); INSERT INTO `t_student` VALUES (10050 '宋致远' 'mbj6fi5LVJ' 'EvI1OF2mUU'); INSERT INTO `t_student` VALUES (10051 '向杰宏' 'rdTBGDlk1e' 'KLrEH5OIRV'); INSERT INTO `t_student` VALUES (10052 '侯岚' 'vRIL8GezRB' 'BCnlCfMe3i'); INSERT INTO `t_student` VALUES (10053 '郝震南' 'N5OHE7WNRd' 'YSEMSIBoF6'); INSERT INTO `t_student` VALUES (10054 '田晓明' 'JFjgjbtPYw' 'C1GMv8jJI4'); INSERT INTO `t_student` VALUES (10055 '金岚' 'gpRnYYtKUp' 'I7Ha61aFlW'); INSERT INTO `t_student` VALUES (10056 '何晓明' 'mIUWaHvpVT' '0sGahlQonR'); INSERT INTO `t_student` VALUES (10057 '吕睿' 'FfkVgyM5SS' 'ie36JBbaUq'); INSERT INTO `t_student` VALUES (10058 '段岚' 'qZWlkeuZou' 'UxP4bndlVw'); INSERT INTO `t_student` VALUES (10059 '宋詩涵' 'McHsYoxoix' 'QedjPd3cfE'); INSERT INTO `t_student` VALUES (10060 '谢秀英' 'Pw2td9ptEO' 'YCdTBkV5u1'); INSERT INTO `t_student` VALUES (10061 '姚睿' 't4zYkGf3fF' '848evloRxx'); INSERT INTO `t_student` VALUES (10062 '贺安琪' '1RjkUEhkZY' '4f0WkjDBkk'); INSERT INTO `t_student` VALUES (10063 '段嘉伦' 'qPY9LKYuqQ' 'jeBmxO9JHj'); INSERT INTO `t_student` VALUES (10064 '唐震南' 'r6bXO95F2D' 'X3HbgEcK8Y'); INSERT INTO `t_student` VALUES (10065 '谢岚' 'naL2KZrHwA' 'AkqosUcsuV'); INSERT INTO `t_student` VALUES (10066 '杨安琪' 'AX8Deo1g7Q' 'qaF4nJ5WpP'); INSERT INTO `t_student` VALUES (10067 '吴杰宏' 'GMzkfndLZv' 'tVfNr43Awi'); INSERT INTO `t_student` VALUES (10068 '曹晓明' '3MhPP9Ba2T' 'WdLUDxvV4D'); INSERT INTO `t_student` VALUES (10069 '赵杰宏' 'bifOEeXCWu' 'LOYM3jaDT2'); INSERT INTO `t_student` VALUES (10070 '钟安琪' 'RaRkUvlMKo' 'YZvGiLMMPa'); INSERT INTO `t_student` VALUES (10071 '向云熙' 'JLLo5dbzOE' 'dwjwJlsE2J'); INSERT INTO `t_student` VALUES (10072 '雷晓明' 'SzkAnohkjE' 'vEI4b77pR7'); INSERT INTO `t_student` VALUES (10073 '汪云熙' 'Dx0e0UItxA' 'phZtzNxzOq'); INSERT INTO `t_student` VALUES (10074 '杨子异' 'fD9kEW1Sq6' 'zImkNQBSUQ'); INSERT INTO `t_student` VALUES (10075 '郭睿' 'JnzPqdQDt8' 'gEcH8ew4sF'); INSERT INTO `t_student` VALUES (10076 '沈子韬' 'ttt1sSrCzJ' '5ywB4pgDqm'); INSERT INTO `t_student` VALUES (10077 '朱子异' 'XnNaK6Q9gu' 'lVWPPYWbTy'); INSERT INTO `t_student` VALUES (10078 '侯璐' 'FqbUPAxjR1' 'hTWsxzLogn'); INSERT INTO `t_student` VALUES (10079 '许宇宁' 'LkzJ9oO3PV' 'sQ12axSWyz'); INSERT INTO `t_student` VALUES (10080 '高云熙' '89PlIz8Y7B' 'h8VtFDBIgf'); INSERT INTO `t_student` VALUES (10081 '杜安琪' 'EIeSoLwSW3' 'dla1wIhe3w'); INSERT INTO `t_student` VALUES (10082 '冯嘉伦' 'Ot9OQzc5Tf' 'HpucsNAfnU'); INSERT INTO `t_student` VALUES (10083 '彭子韬' 'UkeqT8NtJX' '3fPftOFs96'); INSERT INTO `t_student` VALUES (10084 '史震南' 'C1ONnCOf1a' '2wTfHZYsnV'); INSERT INTO `t_student` VALUES (10085 '尹云熙' 'pPD5hlAxiW' 'R9yAP19RJH'); INSERT INTO `t_student` VALUES (10086 '许震南' 'tHPwJY3CDY' 'kwd4uH98o3'); INSERT INTO `t_student` VALUES (10087 '李安琪' 'K2r0WllYzO' 'kNRVRYv0qr'); INSERT INTO `t_student` VALUES (10088 '林子异' '8Ttbp7gc06' 'lj7SdtOYwS'); INSERT INTO `t_student` VALUES (10089 '严嘉伦' 'PNIs8LHIUr' '7XVizBwqrW'); INSERT INTO `t_student` VALUES (10090 '黎杰宏' 'rmjckwsCP6' 'O7BYlHG8A5'); INSERT INTO `t_student` VALUES (10091 '梁杰宏' 'ya3q3e30R9' 'ZpToh85AMq'); INSERT INTO `t_student` VALUES (10092 '张晓明' 'mkY7T8tpA6' 'PW3j7y3ZQS'); INSERT INTO `t_student` VALUES (10093 '吴致远' 'ba5fmbCSUO' 'MMfkS9Lwr7'); INSERT INTO `t_student` VALUES (10094 '陶詩涵' '7bWA6xXp1A' 'Tlo0LxVlVH'); INSERT INTO `t_student` VALUES (10095 '曹睿' 'N08y7yJu15' '8ue93KnrvI'); INSERT INTO `t_student` VALUES (10096 '方宇宁' 't9xDmfZaEQ' 'Xm9umRA1Uc'); INSERT INTO `t_student` VALUES (10097 '曹安琪' 'vG4ZtAQanT' 'Vth5vsry9y'); INSERT INTO `t_student` VALUES (10098 '杨子异' 'YUf12JCtO6' '8999nWETCU'); INSERT INTO `t_student` VALUES (10099 '于杰宏' 'l3NbjhRoCR' 'qCPLVovMjL'); INSERT INTO `t_student` VALUES (10100 '郑震南' 'G3nVY0YbM8' 'vLRejxC1Ve'); -- ---------------------------- -- Table structure for t_video -- ---------------------------- DROP TABLE IF EXISTS `t_video`; CREATE TABLE `t_video` ( `id` int(10) NOT NULL AUTO_INCREMENT `c_id` int(10) 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 (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10145 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_video -- ---------------------------- INSERT INTO `t_video` VALUES (10001 10001 'Navicat Monitor requires ' 'https://video.nishiminat.com/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10002 10003 'To successfully establish ' 'https://video.kamtl.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10003 10002 'How we spend our days ' 'http://video.kjialun.net/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10004 10003 'To successfully establish ' 'https://video.hyhan56.net/Handcrafts'); INSERT INTO `t_video` VALUES (10005 10002 'If the Show objects under ' 'http://video.shishih.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10006 10003 'Anyone who has ever made ' 'https://video.anme7.com/Books'); INSERT INTO `t_video` VALUES (10007 10002 'To get a secure connection ' 'http://video.manuelell60.info/HealthBabyCare'); INSERT INTO `t_video` VALUES (10008 10002 'To successfully establish ' 'http://video.imi10.us/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10009 10003 'It provides strong authentication ' 'https://video.miutszching.org/Appliances'); INSERT INTO `t_video` VALUES (10010 10001 'There is no way to happiness. ' 'http://video.vasquedwa.biz/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10011 10001 'Import Wizard allows ' 'http://video.stszhin.org/CDsVinyl'); INSERT INTO `t_video` VALUES (10012 10002 'Flexible settings enable ' 'http://video.psarah.us/Others'); INSERT INTO `t_video` VALUES (10013 10001 'To connect to a database ' 'http://video.yamadsara.jp/Food'); INSERT INTO `t_video` VALUES (10014 10002 'If you wait all that ' 'https://video.wfts1.co.jp/ToysGames'); INSERT INTO `t_video` VALUES (10015 10003 'It wasn’t raining when ' 'http://video.cook77.net/ToysGames'); INSERT INTO `t_video` VALUES (10016 10002 'Success consists of going ' 'http://video.zhiyuanding.us/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10017 10003 'In other words Navicat ' 'https://video.waiyeesiu.biz/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10018 10002 'If the Show objects under ' 'http://video.sumwinglok.biz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10019 10001 'I will greet this day ' 'https://video.carol3.net/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10020 10002 'SQL Editor allows you ' 'https://video.kad.xyz/MusicalInstrument'); INSERT INTO `t_video` VALUES (10021 10003 'In the Objects tab you ' 'https://video.luj.org/SportsOutdoor'); INSERT INTO `t_video` VALUES (10022 10003 'It collects process metrics ' 'https://video.laws10.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10023 10001 'Navicat provides powerful ' 'https://video.xiaoming9.net/Appliances'); INSERT INTO `t_video` VALUES (10024 10002 'A man’s best friends ' 'http://video.zhiyuliang8.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10025 10002 'It wasn’t raining when ' 'https://video.hu1942.us/CDsVinyl'); INSERT INTO `t_video` VALUES (10026 10001 'Anyone who has never ' 'https://video.shim.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10027 10001 'The reason why a great ' 'http://video.hazukio.org/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10028 10002 'Creativity is intelligence having fun.' 'http://video.matsudae07.cn/ToysGames'); INSERT INTO `t_video` VALUES (10029 10002 'Optimism is the one quality ' 'https://video.zhenjiang711.jp/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10030 10001 'A query is used to extract ' 'http://video.karyanchoi.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10031 10001 'To successfully establish ' 'http://video.kaming43.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10032 10001 'To successfully establish ' 'http://video.ylu321.net/FilmSupplies'); INSERT INTO `t_video` VALUES (10033 10002 'In other words Navicat ' 'https://video.bt10.info/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10034 10002 'There is no way to happiness. ' 'http://video.hung9.co.jp/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10035 10002 'The first step is as good as half over.' 'https://video.muran.jp/Baby'); INSERT INTO `t_video` VALUES (10036 10001 'All the Navicat Cloud ' 'http://video.gonzalezbru85.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10037 10002 'Navicat 15 has added ' 'https://video.jesusoto.co.jp/Appliances'); INSERT INTO `t_video` VALUES (10038 10001 'It wasn’t raining when ' 'http://video.carant.co.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10039 10002 'If your Internet Service ' 'http://video.edwards1.jp/CDsVinyl'); INSERT INTO `t_video` VALUES (10040 10002 'You must be the change ' 'https://video.zhiyuan2.org/FilmSupplies'); INSERT INTO `t_video` VALUES (10041 10002 'All journeys have secret ' 'https://video.tlwan4.net/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10042 10001 'It wasn’t raining when ' 'http://video.hanzit.xyz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10043 10002 'Import Wizard allows ' 'http://video.willimoore83.net/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10044 10003 'Navicat is a multi-connections ' 'https://video.porter620.cn/ToysGames'); INSERT INTO `t_video` VALUES (10045 10002 'Navicat Data Modeler ' 'http://video.su715.com/Food'); INSERT INTO `t_video` VALUES (10046 10001 'Remember that failure ' 'https://video.watsonapril.jp/FilmSupplies'); INSERT INTO `t_video` VALUES (10047 10003 'Import Wizard allows ' 'http://video.sarahriv10.xyz/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10048 10001 'Navicat Cloud could not ' 'http://video.medw.org/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10049 10002 'It collects process metrics ' 'http://video.okamomo.com/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10050 10003 'Navicat 15 has added ' 'http://video.renaokada.xyz/Others'); INSERT INTO `t_video` VALUES (10051 10003 'The On Startup feature ' 'https://video.rythomas104.info/Beauty'); INSERT INTO `t_video` VALUES (10052 10001 'You will succeed because ' 'http://video.saitoaoshi.co.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10053 10001 'Navicat is a multi-connections ' 'http://video.lzhen.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10054 10003 'If it scares you it ' 'https://video.barnes722.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10055 10002 'HTTP Tunneling is a method ' 'http://video.man1.us/SportsOutdoor'); INSERT INTO `t_video` VALUES (10056 10003 'The On Startup feature ' 'https://video.he506.us/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10057 10001 'Navicat Monitor requires ' 'https://video.myam.info/ToysGames'); INSERT INTO `t_video` VALUES (10058 10003 'Import Wizard allows ' 'https://video.sy7.org/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10059 10002 'Success consists of going ' 'https://video.itsuki521.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10060 10003 'It wasn’t raining when ' 'https://video.hsuankwokkuen1970.org/PetSupplies'); INSERT INTO `t_video` VALUES (10061 10003 'Remember that failure ' 'http://video.cht.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10062 10003 'The Synchronize to Database ' 'https://video.nakayama17.biz/Baby'); INSERT INTO `t_video` VALUES (10063 10003 'There is no way to happiness. ' 'http://video.albjohnson.net/HealthBabyCare'); INSERT INTO `t_video` VALUES (10064 10003 'SQL Editor allows you ' 'http://video.kasumiarai.co.jp/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10065 10001 'Navicat allows you to ' 'https://video.parker621.com/VideoGames'); INSERT INTO `t_video` VALUES (10066 10001 'SQL Editor allows you ' 'http://video.sato1222.co.jp/MusicalInstrument'); INSERT INTO `t_video` VALUES (10067 10003 'Difficult circumstances ' 'http://video.yli614.us/CDsVinyl'); INSERT INTO `t_video` VALUES (10068 10003 'It wasn’t raining when ' 'http://video.miliksun.net/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10069 10003 'In a Telnet session ' 'https://video.debrama.cn/AutomotivePartsAccessories'); INSERT INTO `t_video` VALUES (10070 10001 'If opportunity doesn’t ' 'http://video.eitamatsu.org/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10071 10003 'Typically it is employed ' 'http://video.jamesaguilar.org/Baby'); INSERT INTO `t_video` VALUES (10072 10002 'I will greet this day ' 'https://video.aokimis.com/Baby'); INSERT INTO `t_video` VALUES (10073 10002 'The repository database ' 'https://video.kasumiwa2003.cn/ToysGames'); INSERT INTO `t_video` VALUES (10074 10001 'In the middle of winter ' 'https://video.phillipsj.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10075 10001 'Difficult circumstances ' 'https://video.lli627.jp/SportsOutdoor'); INSERT INTO `t_video` VALUES (10076 10001 'It wasn’t raining when ' 'http://video.nanaminishimura7.xyz/Handcrafts'); INSERT INTO `t_video` VALUES (10077 10001 'A query is used to extract ' 'http://video.hasegak925.us/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10078 10003 'The Information Pane ' 'http://video.takasumi.jp/FilmSupplies'); INSERT INTO `t_video` VALUES (10079 10003 'Always keep your eyes ' 'https://video.huimeicho75.info/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10080 10002 'In the Objects tab you ' 'https://video.ashley66.com/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10081 10002 'You must be the change ' 'http://video.anqiwe.info/CDsVinyl'); INSERT INTO `t_video` VALUES (10082 10003 'A man is not old until ' 'http://video.miuraitsuki.xyz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10083 10002 'In the middle of winter ' 'http://video.sad.biz/HealthBabyCare'); INSERT INTO `t_video` VALUES (10084 10003 'Navicat Monitor can be ' 'http://video.sm513.xyz/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10085 10001 'Flexible settings enable ' 'http://video.rihi.xyz/PetSupplies'); INSERT INTO `t_video` VALUES (10086 10003 'It provides strong authentication ' 'https://video.weddie.biz/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10087 10002 'It provides strong authentication ' 'http://video.tsand.com/Baby'); INSERT INTO `t_video` VALUES (10088 10001 'In the middle of winter ' 'http://video.matsusakura.org/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10089 10002 'Instead of wondering ' 'http://video.ayato129.com/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10090 10002 'In a Telnet session ' 'https://video.ngliksun44.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10091 10001 'In the middle of winter ' 'https://video.lanf80.cn/Books'); INSERT INTO `t_video` VALUES (10092 10003 'Genius is an infinite ' 'http://video.wp9.co.jp/Baby'); INSERT INTO `t_video` VALUES (10093 10003 'A man’s best friends ' 'https://video.tangcm1956.net/AppsGames'); INSERT INTO `t_video` VALUES (10094 10003 'Navicat provides powerful ' 'http://video.mingyung2018.com/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10095 10002 'Monitored servers include ' 'https://video.wl01.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10096 10001 'Secure SHell (SSH) is ' 'https://video.yu713.info/PetSupplies'); INSERT INTO `t_video` VALUES (10097 10002 'Navicat Monitor requires ' 'https://video.fongchiming901.biz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10098 10002 'In other words Navicat ' 'https://video.jose17.co.jp/Food'); INSERT INTO `t_video` VALUES (10099 10003 'A comfort zone is a beautiful ' 'https://video.xiayuni.biz/FilmSupplies'); INSERT INTO `t_video` VALUES (10100 10001 'There is no way to happiness. ' 'http://video.mo1997.xyz/Beauty'); INSERT INTO `t_video` VALUES (10101 10001 'SSH serves to prevent ' 'http://video.lsha6.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10102 10003 'It can also manage cloud ' 'http://video.txiuy51.jp/Beauty'); INSERT INTO `t_video` VALUES (10103 10003 'If you wait all that ' 'http://video.arthurmo.biz/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10104 10001 'The first step is as good as half over.' 'http://video.kwokyin306.org/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10105 10003 'Remember that failure ' 'http://video.qiuzit4.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10106 10002 'Navicat Monitor requires ' 'http://video.ricet.jp/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10107 10002 'To open a query using ' 'https://video.hashino.us/Others'); INSERT INTO `t_video` VALUES (10108 10003 'The Synchronize to Database ' 'http://video.nelsondavid10.xyz/ToysGames'); INSERT INTO `t_video` VALUES (10109 10003 'Genius is an infinite ' 'https://video.lauwl1958.info/MusicalInstrument'); INSERT INTO `t_video` VALUES (10110 10002 'Navicat Monitor is a ' 'https://video.jia915.co.jp/HealthBabyCare'); INSERT INTO `t_video` VALUES (10111 10003 'The first step is as good as half over.' 'https://video.sanakayama.xyz/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10112 10001 'Export Wizard allows ' 'https://video.watam.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10113 10001 'Remember that failure ' 'http://video.ntsub.biz/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10114 10001 'Secure Sockets Layer(SSL) ' 'http://video.tsubas.us/FilmSupplies'); INSERT INTO `t_video` VALUES (10115 10001 'You will succeed because ' 'https://video.moralrub.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10116 10001 'If you wait all that ' 'http://video.kathreynolds.biz/Appliances'); INSERT INTO `t_video` VALUES (10117 10003 'If the Show objects under ' 'https://video.rche.us/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10118 10002 'After logged in the Navicat ' 'http://video.sefukud3.biz/CDsVinyl'); INSERT INTO `t_video` VALUES (10119 10002 'The reason why a great ' 'https://video.yinchiehlun.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10120 10001 'A query is used to extract ' 'http://video.jialungu.xyz/CDsVinyl'); INSERT INTO `t_video` VALUES (10121 10001 'To clear or reload various ' 'http://video.soto5.cn/SportsOutdoor'); INSERT INTO `t_video` VALUES (10122 10001 'How we spend our days ' 'http://video.shingkm.xyz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10123 10001 'A man is not old until ' 'https://video.karenbryant.com/ToysGames'); INSERT INTO `t_video` VALUES (10124 10001 'You will succeed because ' 'http://video.yanshih4.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10125 10003 'SQL Editor allows you ' 'http://video.fskwok4.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10126 10002 'To open a query using ' 'https://video.chenrich.cn/VideoGames'); INSERT INTO `t_video` VALUES (10127 10003 'Always keep your eyes ' 'http://video.hyliao6.cn/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10128 10003 'You will succeed because ' 'https://video.mao45.org/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10129 10001 'I may not have gone where ' 'http://video.oghikari.net/Books'); INSERT INTO `t_video` VALUES (10130 10003 'It provides strong authentication ' 'https://video.onhaz2.org/VideoGames'); INSERT INTO `t_video` VALUES (10131 10003 'Success consists of going ' 'http://video.rikuwa.info/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10132 10002 'The repository database ' 'https://video.yuna9.info/AutomotivePartsAccessories'); INSERT INTO `t_video` VALUES (10133 10002 'All the Navicat Cloud ' 'https://video.johnngar.com/Beauty'); INSERT INTO `t_video` VALUES (10134 10001 'Export Wizard allows ' 'http://video.zyuan.com/HealthBabyCare'); INSERT INTO `t_video` VALUES (10135 10003 'The Information Pane ' 'https://video.xuerui9.biz/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10136 10003 'The Main Window consists ' 'https://video.ruixu.xyz/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10137 10001 'In the middle of winter ' 'https://video.wstang.co.jp/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10138 10003 'If the plan doesn’t ' 'https://video.mc93.us/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10139 10002 'It can also manage cloud ' 'https://video.ntingfung.info/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10140 10001 'If the Show objects under ' 'http://video.myunxi43.info/Handcrafts'); INSERT INTO `t_video` VALUES (10141 10001 'If it scares you it ' 'http://video.endh54.xyz/CellPhonesAccessories'); INSERT INTO `t_video` VALUES (10142 10002 'The Information Pane ' 'http://video.takwahmok9.us/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10143 10002 'To connect to a database ' 'http://video.miuramomoe.cn/Appliances'); INSERT INTO `t_video` VALUES (10144 10002 'Navicat is a multi-connections ' 'http://video.lishiha.net/Appliances'); SET FOREIGN_KEY_CHECKS = 1; $