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

《MySQL数据库基础》 期末复习卷(一) 时间:90分钟 总分:100分 班级 姓名 学号 成绩 一．数据库操作题(本大题共5小题,每小题20分,共100分) 1.房屋租赁系统数据库db_lease包含了t_house房屋信息表、t_client客户表和t_order订单表 t_house包含字段hid(房屋编号),address(地址),tel(户主联系电话),type(房屋类型),decoration(装修情况),area(面积),price(每月价格) t_client包含字段 cid(客户编号),name(客户姓名),tel(联系电话),need (需求备注) t_order包含字段oid(订单编号),cid(客户编号),hid(房屋编号),time(租赁时间),duration(租赁时长) 1).创建预约看房表t_appointment,字段如下: aid(预约编号) char(10) 主键 cid(客户编号) char(10) 非空 hid(房屋编号) char(10) 非空 apptime(预约时间) datetime status(状态) varchar(20) 默认待看房 2).向t_appointment表中插入一条数据:预约编号a0001,客户编号c0005,房屋编号h0003,预约时间2025-04-10 14:30:00 3).为t_house表添加status字段(出租状态),类型varchar(20),默认未出租 4).将t_house表中房屋编号h0008的每月价格修改为 2800 5).用SQL语句查询面积大于80平方米且装修情况为精装的所有房屋信息 6).用SQL语句查询客户张三的所有订单,显示客户姓名、房屋地址、租赁时长 7).创建视图v_rent_order,显示订单信息,字段:客户姓名、联系电话、房屋地址、每月价格、租赁时长 答案: 1).CREATE TABLE t_appointment ( aid CHAR(10) PRIMARY KEY, cid CHAR(10) NOT NULL, hid CHAR(10) NOT NULL, apptime DATETIME, status VARCHAR(20) DEFAULT '待看房'); 2).INSERT INTO t_appointment (aid, cid, hid, apptime) VALUES ('a0001', 'c0005', 'h0003', '2025-04-10 14:30:00'); 3).ALTER TABLE t_house ADD status VARCHAR(20) DEFAULT '未出租'; 4).UPDATE t_house SET price = 2800 WHERE hid = 'h0008'; 5).SELECT * FROM t_house WHERE area > 80 AND decoration = '精装'; 6).SELECT c.name, h.address, o.duration FROM t_order o JOIN t_client c ON o.cid = c.cid JOIN t_house h ON o.hid = h.hid WHERE c.name = '张三'; 7).CREATE VIEW v_rent_order ASSELECT c.name AS 客户姓名, c.tel AS 联系电话,h.address AS 房屋地址, h.price AS 每月价格, o.duration AS 租赁时长 FROM t_order o JOIN t_client c ON o.cid = c.cid JOIN t_house h ON o.hid = h.hid; 2.社交网络数据库db_social包含了t_user用户表、t_friendship好友关系表、t_post动态表、点赞表 t_user包含字段uid(用户编号),username(用户名),password(密码),nickname(昵称),age(年龄),sex(性别)。 t_friendship包含字段fsid(好友关系编号),uid(用户id),fid(好友id),createtime(添加时间)。 t_post包含字段pid(动态编号),uid(用户编号),content(内容),createtime(创建时间) t_likes包含字段lid(点赞编号),pid(动态编号),fid(好友id),createtime(点赞时间) 1).创建评论表t_comment,字段如下: cmid(评论编号) char(10) 主键 pid(动态编号) char(10) 非空 uid(用户编号) char(10) 非空 content(评论内容) text createtime(创建时间) datetime 2).向t_comment表中插入一条数据:评论编号c0001,动态编号p0002,用户编号u0005,评论内容写得真好,创建时间2025-04-01 10:00:00 3).为t_user表添加regtime字段(注册时间),类型datetime 4).将t_user表中用户编号u0010的昵称修改为阳光男孩 5).用SQL语句查询年龄在18-25岁之间的所有女性用户信息 6).用SQL语句查询用户李明的所有好友昵称和添加时间 7).创建视图v_user_likes,显示用户点赞记录,字段:昵称、动态内容、点赞时 8).创建触发器:当向t_likes表中插入一条点赞记录时,自动更新对应动态的点赞数量字段 9).创建存储过程proc_add_friend,输入参数为两个用户编号(uid1, uid2),实现双向添加好友 答案: 1).CREATE TABLE t_comment (cmid CHAR(10) PRIMARY KEY, pid CHAR(10) NOT NULL,uid CHAR(10) NOT NULL,content TEXT,createtime DATETIME); 2).INSERT INTO t_comment (cmid, pid, uid, content, createtime) VALUES ('c0001', 'p0002', 'u0005', '写得真好', '2025-04-01 10:00:00'); 3).ALTER TABLE t_user ADD regtime DATETIME; 4).UPDATE t_user SET nickname = '阳光男孩' WHERE uid = 'u0010'; 5).SELECT * FROM t_user WHERE age BETWEEN 18 AND 25 AND sex = '女'; 6).SELECT u.nickname, f.createtime FROM t_friendship f JOIN t_user u ON f.fid = u.uid JOIN t_user cu ON f.uid = cu.uid WHERE cu.username = '李明'; 7).CREATE VIEW v_user_likes ASSELECT u.nickname AS 昵称, p.content AS 动态内容, l.createtime AS 点赞时间FROM t_likes l JOIN t_user u ON l.fid = u.uid JOIN t_post p ON l.pid = p.pid; 8).CREATE TRIGGER trg_update_likes_count AFTER INSERT ON t_likes FOR EACH ROWBEGIN UPDATE t_post SET likes_count = likes_count + 1 WHERE pid = NEW.pid;END; 9). DELIMITER //CREATE PROCEDURE proc_add_friend(IN uid1 CHAR(10), IN uid2 CHAR(10))BEGIN INSERT INTO t_friendship (fsid, uid, fid, createtime) VALUES (CONCAT(uid1, '_', uid2), uid1, uid2, NOW()); INSERT INTO t_friendship (fsid, uid, fid, createtime) VALUES (CONCAT(uid2, '_', uid1), uid2, uid1, NOW());END //DELIMITER ; 3.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段sid(学生编号),sname(学生姓名),username(用户名),password(密码),classes(班级)。 t_course包含字段 cid(课程编号),cname(课程名称),description(描述), classhour(课时)。 t_video包括字段vid(视频编号),cid(课程编号),title(标题),link(链接地址) t_Learn学习记录表lid(学习记录编号),sid(学生编号),cid(课程编号),schedule(学习进度),createtime(创建时间)。 1).创建作业表t_homework,字段如下: hid(作业编号) char(10) 主键 cid(课程编号) char(10) 非空 title(作业标题) varchar(100) deadline(截止时间)datetime 2).向t_homework表中插入一条数据:作业编号h0001,课程编号c0003,作业标题第一章课后练习,截止时间2025-04-20 23:59:59 3).为t_student表添加email字段(邮箱),类型 varchar(50) 4).将t_student表中用户名为xiaoming的密码修改为newpass123" 5).用SQL语句查询班级为高二2班的所有学生信息 6).用SQL语句查询数学课程的所有视频信息,显示课程名称、视频标题、链接地址 7).创建视图v_learn_record显示学生学习记录,字段:学生姓名、课程名称、学习进度、创建时间 8).创建触发器:当向t_Learn学习记录表中插入或更新学习进度时,如果进度达到 100%,则自动在t_course表中记录该学生完成该课程(假设t_course中增加字段completed_count统计完成人数) 9).创建存储过程proc_get_course_progress,输入参数为学生编号sid,返回该学生所有课程的学习进度(显示课程名称、进度百分比) 答案: 1).CREATE TABLE t_homework ( hid CHAR(10) PRIMARY KEY, cid CHAR(10) NOT NULL, title VARCHAR(100), deadline DATETIME); 2).INSERT INTO t_homework (hid, cid, title, deadline) VALUES ('h0001', 'c0003', '第一章课后练习', '2025-04-20 23:59:59'); 3).ALTER TABLE t_student ADD email VARCHAR(50); 4).UPDATE t_student SET password = 'newpass123' WHERE username = 'xiaoming'; 5).查询班级学生SELECT * FROM t_student WHERE classes = '高二2班'; 6). SELECT c.cname, v.title, v.link FROM t_video v JOIN t_course c ON v.cid = c.cid WHERE c.cname = '数学'; 7).CREATE VIEW v_learn_record ASSELECT s.sname AS 学生姓名, c.cname AS 课程名称, l.schedule AS 学习进度, l.createtime AS 创建时间FROM t_Learn l JOIN t_student s ON l.sid = s.sid JOIN t_course c ON l.cid = c.cid; 8).CREATE TRIGGER trg_update_completed AFTER INSERT ON t_Learn FOR EACH ROWBEGIN IF NEW.schedule = 100 THEN UPDATE t_course SET completed_count = completed_count + 1 WHERE cid = NEW.cid; END IF;END; 9).DELIMITER //CREATE PROCEDURE proc_get_course_progress(IN stu_sid CHAR(10))BEGIN SELECT c.cname AS 课程名称, CONCAT(l.schedule, '%') AS 进度百分比 FROM t_Learn l JOIN t_course c ON l.cid = c.cid WHERE l.sid = stu_sid;END //DELIMITER ; 4.学生成绩系统数据库db_grade包含了t_student学生表t_grade成绩表和t_course科目表 t_student包含字段sid(学生编号),sname(姓名),sex(性别),class(班级)。 t_course包含字段 cid(科目编号),cname(科目名称),total(总分)。 t_grade包含字段gid(成绩编号),sid(学生编号),cid(科目编号),score (分数)。 1).创建成绩分析表 t_analysis,字段如下: aid(分析编号) char(10) 主键 sid(学生编号) char(10) 非空 avgscore(平均分) decimal(5,2) rank(排名) int updatetime(更新时间) datetime 2).向t_analysis表中插入一条数据:分析编号a0001,学生编号s0002,平均分 85.5,排名 3,更新时间2025-04-01 3).为t_course表添加credit字段(学分),类型 int,默认 2 4).将t_course表中科目编号c0005的总分修改为 120 5).用SQL语句查询班级为高三1班的所有学生信息 6).用SQL语句查询数学科目成绩大于 90 分的学生,显示学生姓名、班级、数学成绩 7).创建视图v_student_grade,显示学生成绩,字段:学生姓名、班级、科目名称、分数、总分 8).创建触发器:当向t_grade成绩表中插入或更新分数时,自动计算该学生的平均分并更新到t_analysis表中 9).创建存储过程proc_class_rank,输入参数为班级名称和科目编号,返回该班级在该科目中的学生成绩排名(按分数从高到低) 答案: 1).CREATE TABLE t_analysis ( aid CHAR(10) PRIMARY KEY, sid CHAR(10) NOT NULL, avgscore DECIMAL(5,2),rank INT, updatetime DATETIME); 2).INSERT INTO t_analysis (aid, sid, avgscore, rank, updatetime) VALUES ('a0001', 's0002', 85.5, 3, '2025-04-01'); 3).ALTER TABLE t_course ADD credit INT DEFAULT 2; 4).UPDATE t_course SET total = 120 WHERE cid = 'c0005'; 5).SELECT * FROM t_student WHERE class = '高三1班'; 6).SELECT s.sname, s.class, g.score FROM t_grade g JOIN t_student s ON g.sid = s.sid JOIN t_course c ON g.cid = c.cid WHERE c.cname = '数学' AND g.score > 90; 7).CREATE VIEW v_student_grade ASSELECT s.sname AS 学生姓名, s.class AS 班级, c.cname AS 科目名称, g.score AS 分数, c.total AS 总分FROM t_grade g JOIN t_student s ON g.sid = s.sid JOIN t_course c ON g.cid = c.cid; 8).CREATE TRIGGER trg_update_avgscore AFTER INSERT ON t_grade FOR EACH ROWBEGIN DECLARE avg_score DECIMAL(5,2); SELECT AVG(score) INTO avg_score FROM t_grade WHERE sid = NEW.sid; UPDATE t_analysis SET avgscore = avg_score, updatetime = NOW() WHERE sid = NEW.sid;END; 9). DELIMITER //CREATE PROCEDURE proc_class_rank(IN class_name VARCHAR(50), IN course_id CHAR(10))BEGIN SELECT s.sname, g.score, RANK() OVER (ORDER BY g.score DESC) AS 排名 FROM t_grade g JOIN t_student s ON g.sid = s.sid WHERE s.class = class_name AND g.cid = course_id ORDER BY g.score DESC;END //DELIMITER ; 5.医疗管理数据库db_treatment包含了t_patient患者表、t_doctor医生表、t_registration挂号表 t_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 t_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 t_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 1).创建病历表 t_medical,字段如下: mid(病历编号) char(10) 主键 pid(患者编号) char(10) 非空 did(医生编号) char(10) 非空 diagnosis(诊断结果) text medtime(就诊时间) datetime 2).向t_medical表中插入一条数据:病历编号m0001,患者编号p0004,医生编号d0002,诊断结果上呼吸道感染,就诊时间2025-04-03 09:30:00 3).为t_doctor表添加years字段(工作年限),类型 int,默认 0 4).将t_doctor表中医生编号d0010的联系电话修改为13812345678 5).用SQL语句查询所有内科医生的姓名、职称和联系电话 6).用SQL语句查询患者王芳的所有挂号记录,显示患者姓名、医生姓名、科室、挂号日期 7).创建视图v_registration_info,显示挂号信息,字段:患者姓名、联系电话、医生姓名、科室、挂号日期 8).创建触发器:当向t_registration挂号表中插入一条记录时,自动检查该医生当天挂号人数是否超过30人,如果超过则拒绝插入 9).创建存储过程proc_doctor_patient_count,输入参数为医生编号和挂号日期,返回该医生在指定日期的挂号患者数量 答案: 1).CREATE TABLE t_medical ( mid CHAR(10) PRIMARY KEY, pid CHAR(10) NOT NULL, did CHAR(10) NOT NULL, diagnosis TEXT, medtime DATETIME); 2).INSERT INTO t_medical (mid, pid, did, diagnosis, medtime) VALUES ('m0001', 'p0004', 'd0002', '上呼吸道感染', '2025-04-03 09:30:00'); 3).ALTER TABLE t_doctor ADD years INT DEFAULT 0; 4).UPDATE t_doctor SET tel = '13812345678' WHERE did = 'd0010'; 5).SELECT dname, title, tel FROM t_doctor WHERE office = '内科';-- 6). 查询患者王芳的挂号记录SELECT p.pname, d.dname, d.office, r.rtime FROM t_registration r JOIN t_patient p ON r.pid = p.pid JOIN t_doctor d ON r.did = d.did WHERE p.pname = '王芳'; 7).CREATE VIEW v_registration_info ASSELECT p.pname AS 患者姓名, p.tel AS 联系电话,d.dname AS 医生姓名, d.office AS 科室, r.rtime AS 挂号日期FROM t_registration r JOIN t_patient p ON r.pid = p.pid JOIN t_doctor d ON r.did = d.did; 8).DELIMITER //CREATE TRIGGER trg_check_registration_limit BEFORE INSERT ON t_registration FOR EACH ROWBEGIN DECLARE today_count INT; SELECT COUNT(*) INTO today_count FROM t_registration WHERE did = NEW.did AND DATE(rtime) = DATE(NEW.rtime);IF today_count >= 30 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = '该医生当天挂号人数已超过30人'; END IF;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE proc_doctor_patient_count(IN doctor_id CHAR(10), IN reg_date DATE, OUT patient_count INT) BEGIN SELECT COUNT(*) INTO patient_count FROM t_registration WHERE did = doctor_id AND DATE(rtime) = reg_date;END //DELIMITER ; 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题一/db_lease.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_lease Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 23/11/2023 10:28:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_client -- ---------------------------- DROP TABLE IF EXISTS `t_client`; CREATE TABLE `t_client` ( `cid` int(11) NULL DEFAULT NULL, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `need` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_client -- ---------------------------- INSERT INTO `t_client` VALUES (10001, '蔡致远', '19503210699', '精装'); INSERT INTO `t_client` VALUES (10002, '谢子异', '7696954760', '两室'); INSERT INTO `t_client` VALUES (10003, '田宇宁', '108144296', '毛胚'); INSERT INTO `t_client` VALUES (10004, '沈杰宏', '104971363', '两室'); INSERT INTO `t_client` VALUES (10005, '汤睿', '2068695528', '毛胚'); INSERT INTO `t_client` VALUES (10006, '薛岚', '14879352296', '毛胚'); INSERT INTO `t_client` VALUES (10007, '秦岚', '13545030053', '单间'); INSERT INTO `t_client` VALUES (10008, '郑杰宏', '2183213547', '毛胚'); INSERT INTO `t_client` VALUES (10009, '谢秀英', '14067372900', '单间'); INSERT INTO `t_client` VALUES (10010, '范致远', '18789991507', '单间'); INSERT INTO `t_client` VALUES (10011, '杨云熙', '19481632713', '两室'); INSERT INTO `t_client` VALUES (10012, '石子异', '2165515768', '单间'); INSERT INTO `t_client` VALUES (10013, '韦秀英', '2872609276', '两室'); INSERT INTO `t_client` VALUES (10014, '张致远', '76035737758', '精装'); INSERT INTO `t_client` VALUES (10015, '孙詩涵', '17793665808', '单间'); INSERT INTO `t_client` VALUES (10016, '陶嘉伦', '18568570306', '精装'); INSERT INTO `t_client` VALUES (10017, '徐晓明', '15655432389', '简装'); INSERT INTO `t_client` VALUES (10018, '何云熙', '19437875223', '简装'); INSERT INTO `t_client` VALUES (10019, '孙杰宏', '289342263', '精装'); INSERT INTO `t_client` VALUES (10020, '范震南', '13121528802', '毛胚'); -- ---------------------------- -- Table structure for t_house -- ---------------------------- DROP TABLE IF EXISTS `t_house`; CREATE TABLE `t_house` ( `hid` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` int(20) NULL DEFAULT NULL, `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `decoration` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `area` int(5) NULL DEFAULT NULL, `price` int(5) NULL DEFAULT NULL, PRIMARY KEY (`hid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_house -- ---------------------------- INSERT INTO `t_house` VALUES (10001, '中国北京市西城区西長安街354号43室', 10146743, '三室一厅', '精装', 73, 1705); INSERT INTO `t_house` VALUES (10002, '中国东莞环区南街二巷284号28室', 18084482, '三室两厅', '精装', 102, 889); INSERT INTO `t_house` VALUES (10003, '中国北京市海淀区清河中街68号478号31栋', 15712749, '三室两厅', '精装', 96, 1000); INSERT INTO `t_house` VALUES (10004, '中国深圳龙岗区学园一巷533号41栋', 19563209, '三室一厅', '毛胚', 125, 1921); INSERT INTO `t_house` VALUES (10005, '中国中山乐丰六路892号华润大厦41室', 19823516, '三室两厅', '毛胚', 74, 1271); INSERT INTO `t_house` VALUES (10006, '中国上海市浦东新区健祥路633号22楼', 16335231, '两室一厅', '精装', 112, 1179); INSERT INTO `t_house` VALUES (10007, '中国东莞环区南街二巷658号45楼', 19297583, '三室一厅', '简装', 92, 1843); INSERT INTO `t_house` VALUES (10008, '中国中山京华商圈华夏街595号华润大厦31室', 12692049, '三室两厅', '毛胚', 93, 1212); INSERT INTO `t_house` VALUES (10009, '中国北京市房山区岳琉路334号38号楼', 18408913, '一室一厅', '精装', 115, 1298); INSERT INTO `t_house` VALUES (10010, '中国深圳罗湖区清水河一路25号34室', 14485481, '三室两厅', '精装', 112, 985); INSERT INTO `t_house` VALUES (10011, '中国东莞东泰五街26号29号楼', 13695465, '三室一厅', '精装', 85, 1084); INSERT INTO `t_house` VALUES (10012, '中国广州市白云区机场路棠苑街五巷771号华润大厦43室', 17241769, '两室一厅', '毛胚', 84, 1072); INSERT INTO `t_house` VALUES (10013, '中国中山紫马岭商圈中山五路68号8楼', 19474063, '三室一厅', '毛胚', 114, 1434); INSERT INTO `t_house` VALUES (10014, '中国北京市東城区東直門內大街509号26栋', 18408702, '三室两厅', '精装', 83, 1152); INSERT INTO `t_house` VALUES (10015, '中国广州市海珠区江南西路13号10室', 13507746, '三室一厅', '精装', 79, 1408); INSERT INTO `t_house` VALUES (10016, '中国广州市天河区天河路660号18栋', 17834698, '两室一厅', '精装', 110, 1676); INSERT INTO `t_house` VALUES (10017, '中国广州市越秀区中山二路829号11号楼', 15707608, '一室一厅', '毛胚', 113, 1301); INSERT INTO `t_house` VALUES (10018, '中国成都市成华区双庆路404号华润大厦22室', 16839914, '两室一厅', '精装', 90, 1423); INSERT INTO `t_house` VALUES (10019, '中国深圳龙岗区学园一巷217号8楼', 14488797, '一室一厅', '精装', 116, 1331); INSERT INTO `t_house` VALUES (10020, '中国成都市锦江区红星路三段947号25号楼', 10422150, '三室一厅', '精装', 74, 1594); -- ---------------------------- -- Table structure for t_order -- ---------------------------- DROP TABLE IF EXISTS `t_order`; CREATE TABLE `t_order` ( `oid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL, `hid` int(11) NOT NULL, `time` date NULL DEFAULT NULL, `duration` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`oid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order -- ---------------------------- INSERT INTO `t_order` VALUES (10001, 10010, 10008, '2020-12-19', '三个月'); INSERT INTO `t_order` VALUES (10002, 10001, 10020, '2022-01-03', '半年'); INSERT INTO `t_order` VALUES (10003, 10017, 10019, '2020-05-14', '半年'); INSERT INTO `t_order` VALUES (10004, 10005, 10004, '2000-11-07', '半年'); INSERT INTO `t_order` VALUES (10005, 10008, 10006, '2001-10-18', '一年'); INSERT INTO `t_order` VALUES (10006, 10020, 10010, '2010-07-29', '一年'); INSERT INTO `t_order` VALUES (10007, 10018, 10017, '2003-12-12', '一年'); INSERT INTO `t_order` VALUES (10008, 10004, 10013, '2001-01-28', '三个月'); INSERT INTO `t_order` VALUES (10009, 10016, 10018, '2023-03-04', '三个月'); INSERT INTO `t_order` VALUES (10010, 10013, 10005, '2012-06-30', '三个月'); INSERT INTO `t_order` VALUES (10011, 10014, 10003, '2010-07-23', '长期'); INSERT INTO `t_order` VALUES (10012, 10007, 10015, '2009-06-03', '三个月'); INSERT INTO `t_order` VALUES (10013, 10009, 10011, '2003-09-29', '长期'); INSERT INTO `t_order` VALUES (10014, 10006, 10009, '2010-05-01', '一年'); INSERT INTO `t_order` VALUES (10015, 10011, 10002, '2021-07-18', '长期'); INSERT INTO `t_order` VALUES (10016, 10015, 10012, '2019-06-19', '半年'); INSERT INTO `t_order` VALUES (10017, 10019, 10016, '2015-05-26', '半年'); INSERT INTO `t_order` VALUES (10018, 10012, 10001, '2018-11-14', '三个月'); INSERT INTO `t_order` VALUES (10019, 10002, 10014, '2016-09-03', '三个月'); INSERT INTO `t_order` VALUES (10020, 10003, 10007, '2013-07-09', '一年'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《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: 05/12/2023 09:42:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(10) NULL DEFAULT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classhour` int(10) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '语文', '高中语文课程', 24); INSERT INTO `t_course` VALUES (10002, '数学', '高中数学课程', 24); INSERT INTO `t_course` VALUES (10003, '英语', '高中英语课程', 24); -- ---------------------------- -- Table structure for t_learn -- ---------------------------- DROP TABLE IF EXISTS `t_learn`; CREATE TABLE `t_learn` ( `lid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `schedule` int(10) NULL DEFAULT 0, `createtime` date NULL DEFAULT NULL, PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_learn -- ---------------------------- INSERT INTO `t_learn` VALUES ('10001', '10026', '10003', 8, '2001-08-21'); INSERT INTO `t_learn` VALUES ('10002', '10044', '10001', 7, '2001-01-30'); INSERT INTO `t_learn` VALUES ('10003', '10024', '10003', 15, '2011-11-02'); INSERT INTO `t_learn` VALUES ('10004', '10029', '10003', 15, '2019-08-20'); INSERT INTO `t_learn` VALUES ('10005', '10042', '10003', 19, '2005-09-13'); INSERT INTO `t_learn` VALUES ('10006', '10033', '10004', 7, '2006-09-05'); INSERT INTO `t_learn` VALUES ('10007', '10043', '10004', 16, '2015-01-16'); INSERT INTO `t_learn` VALUES ('10008', '10037', '10002', 18, '2008-06-16'); INSERT INTO `t_learn` VALUES ('10009', '10010', '10003', 4, '2011-02-08'); INSERT INTO `t_learn` VALUES ('10010', '10034', '10004', 22, '2001-03-18'); INSERT INTO `t_learn` VALUES ('10011', '10021', '10003', 3, '2005-04-02'); INSERT INTO `t_learn` VALUES ('10012', '10036', '10001', 18, '2019-02-23'); INSERT INTO `t_learn` VALUES ('10013', '10002', '10003', 10, '2002-06-14'); INSERT INTO `t_learn` VALUES ('10014', '10030', '10003', 7, '2023-11-04'); INSERT INTO `t_learn` VALUES ('10015', '10011', '10002', 1, '2002-12-28'); INSERT INTO `t_learn` VALUES ('10016', '10035', '10004', 13, '2003-05-17'); INSERT INTO `t_learn` VALUES ('10017', '10014', '10003', 9, '2017-09-01'); INSERT INTO `t_learn` VALUES ('10018', '10015', '10001', 11, '2001-05-26'); INSERT INTO `t_learn` VALUES ('10019', '10012', '10003', 8, '2009-04-21'); INSERT INTO `t_learn` VALUES ('10020', '10017', '10003', 4, '2018-08-24'); INSERT INTO `t_learn` VALUES ('10021', '10003', '10003', 5, '2019-07-31'); INSERT INTO `t_learn` VALUES ('10022', '10038', '10003', 23, '2011-12-29'); INSERT INTO `t_learn` VALUES ('10023', '10032', '10003', 14, '2003-08-19'); INSERT INTO `t_learn` VALUES ('10024', '10039', '10003', 12, '2004-02-06'); INSERT INTO `t_learn` VALUES ('10025', '10041', '10001', 21, '2002-07-12'); INSERT INTO `t_learn` VALUES ('10026', '10006', '10001', 13, '2013-10-15'); INSERT INTO `t_learn` VALUES ('10027', '10020', '10001', 16, '2020-06-08'); INSERT INTO `t_learn` VALUES ('10028', '10008', '10001', 13, '2023-11-18'); INSERT INTO `t_learn` VALUES ('10029', '10007', '10003', 10, '2000-12-21'); INSERT INTO `t_learn` VALUES ('10030', '10049', '10004', 3, '2021-12-24'); INSERT INTO `t_learn` VALUES ('10031', '10047', '10004', 7, '2005-04-17'); INSERT INTO `t_learn` VALUES ('10032', '10023', '10002', 16, '2002-09-10'); INSERT INTO `t_learn` VALUES ('10033', '10019', '10002', 7, '2021-03-27'); INSERT INTO `t_learn` VALUES ('10034', '10001', '10003', 5, '2010-10-03'); INSERT INTO `t_learn` VALUES ('10035', '10028', '10004', 11, '2008-05-06'); INSERT INTO `t_learn` VALUES ('10036', '10016', '10002', 24, '2009-05-27'); INSERT INTO `t_learn` VALUES ('10037', '10009', '10002', 2, '2021-05-03'); INSERT INTO `t_learn` VALUES ('10038', '10027', '10004', 11, '2022-10-06'); INSERT INTO `t_learn` VALUES ('10039', '10040', '10003', 8, '2023-03-01'); INSERT INTO `t_learn` VALUES ('10040', '10031', '10003', 5, '2017-04-23'); INSERT INTO `t_learn` VALUES ('10041', '10050', '10004', 0, '2017-04-16'); INSERT INTO `t_learn` VALUES ('10042', '10025', '10002', 14, '2020-11-18'); INSERT INTO `t_learn` VALUES ('10043', '10048', '10003', 3, '2000-02-01'); INSERT INTO `t_learn` VALUES ('10044', '10005', '10001', 2, '2000-07-30'); INSERT INTO `t_learn` VALUES ('10045', '10046', '10001', 6, '2009-01-21'); INSERT INTO `t_learn` VALUES ('10046', '10004', '10001', 14, '2011-05-07'); INSERT INTO `t_learn` VALUES ('10047', '10022', '10003', 14, '2007-09-05'); INSERT INTO `t_learn` VALUES ('10048', '10013', '10003', 20, '2002-04-02'); INSERT INTO `t_learn` VALUES ('10049', '10018', '10004', 10, '2010-05-19'); INSERT INTO `t_learn` VALUES ('10050', '10045', '10003', 10, '2015-10-31'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(10) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `classes` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '贾子韬', 'rqkpnrpw', 'qGhyfhyGio', '高一1班'); INSERT INTO `t_student` VALUES (10002, '曾詩涵', 'wllbpxpf', 'Ft8qo5iwJ0', '高三2班'); INSERT INTO `t_student` VALUES (10003, '高睿', 'gzairzdb', 'C1L1N4OBX4', '高二2班'); INSERT INTO `t_student` VALUES (10004, '孔璐', 'plgtkjxy', '4ARIJvsdI7', '高三1班'); INSERT INTO `t_student` VALUES (10005, '邱璐', 'dkhtjxob', 'aa9NUeo9sF', '高一1班'); INSERT INTO `t_student` VALUES (10006, '林晓明', 'lbtkgcep', 'q7GaI78tY3', '高三1班'); INSERT INTO `t_student` VALUES (10007, '廖子异', 'heumgwpi', '9iCA9pCACl', '高二2班'); INSERT INTO `t_student` VALUES (10008, '吴宇宁', 'immknini', 'hnlwlWXfMw', '高二2班'); INSERT INTO `t_student` VALUES (10009, '陶致远', 'vaaibzte', 'zSyRZSbTll', '高三2班'); INSERT INTO `t_student` VALUES (10010, '田致远', 'hvmqiebm', 'Fvm4G9VhkZ', '高二2班'); INSERT INTO `t_student` VALUES (10011, '任震南', 'bkqoxgrp', 'ZM5Cw5utTm', '高一2班'); INSERT INTO `t_student` VALUES (10012, '雷岚', 'mhrviqys', '9aVltYbPHE', '高一2班'); INSERT INTO `t_student` VALUES (10013, '傅子韬', 'yxvpgzui', '0sPq0v3IeJ', '高一2班'); INSERT INTO `t_student` VALUES (10014, '韦杰宏', 'bqifzjrt', '9Oo6J5odqP', '高二1班'); INSERT INTO `t_student` VALUES (10015, '马子异', 'zzhjqmrz', 'a1gMAwnLs2', '高三2班'); INSERT INTO `t_student` VALUES (10016, '莫秀英', 'bxktahbz', 'IWCVNvMGL6', '高一2班'); INSERT INTO `t_student` VALUES (10017, '常宇宁', 'xdbqtnqs', 'w8Dn5mTtGp', '高一2班'); INSERT INTO `t_student` VALUES (10018, '朱子异', 'qjstcwjc', 'Zr2mtrMpVE', '高三1班'); INSERT INTO `t_student` VALUES (10019, '方震南', 'syfrtkyu', '2AoUfr5ZnK', '高一1班'); INSERT INTO `t_student` VALUES (10020, '沈宇宁', 'ictjevir', '5F24FmvV1q', '高二2班'); INSERT INTO `t_student` VALUES (10021, '吕安琪', 'caquymom', 'EAQjHmn8z7', '高一2班'); INSERT INTO `t_student` VALUES (10022, '宋璐', 'dpbgvoqx', 'TT3IPCOX5B', '高一1班'); INSERT INTO `t_student` VALUES (10023, '潘秀英', 'bqxhwqdf', 'DNGok5w6CC', '高三1班'); INSERT INTO `t_student` VALUES (10024, '莫詩涵', 'ktmtgcrs', 'OKkp6v553e', '高三1班'); INSERT INTO `t_student` VALUES (10025, '熊璐', 'txfpxsis', 'T54gy0Hb3S', '高三2班'); INSERT INTO `t_student` VALUES (10026, '潘震南', 'ihrjenzb', 'w2R8wdbUug', '高三2班'); INSERT INTO `t_student` VALUES (10027, '陈詩涵', 'qehknger', 'fPp0m6qm4A', '高一2班'); INSERT INTO `t_student` VALUES (10028, '严杰宏', 'swhwmmbn', 'UJpPxYXcfG', '高一1班'); INSERT INTO `t_student` VALUES (10029, '韩璐', 'rgwoyxfj', 'fpRrn8hP7k', '高一1班'); INSERT INTO `t_student` VALUES (10030, '汪詩涵', 'qeiwzawn', 'mdDK734hYf', '高二1班'); INSERT INTO `t_student` VALUES (10031, '尹子异', 'iojbrdtg', '0o3Ymue1Ts', '高一1班'); INSERT INTO `t_student` VALUES (10032, '贾秀英', 'pjrbxcgi', 'wvQ7ul5Ygl', '高二2班'); INSERT INTO `t_student` VALUES (10033, '吕震南', 'oedjepmq', 'EpkZMcblN4', '高三2班'); INSERT INTO `t_student` VALUES (10034, '金杰宏', 'zedxgqur', 'upz5cfstS8', '高二2班'); INSERT INTO `t_student` VALUES (10035, '汪震南', 'azlhdsgv', 'UEjf4k3J4Y', '高一1班'); INSERT INTO `t_student` VALUES (10036, '邹秀英', 'ezcuzosf', 'AVDfHqPSBA', '高一1班'); INSERT INTO `t_student` VALUES (10037, '韦子韬', 'thghwrxm', 'hOPYmq90aI', '高三2班'); INSERT INTO `t_student` VALUES (10038, '邓岚', 'xibjqcqr', 'KHVLMHEdB2', '高二1班'); INSERT INTO `t_student` VALUES (10039, '侯晓明', 'wqsboqtx', '1JlWkJhuin', '高二1班'); INSERT INTO `t_student` VALUES (10040, '方睿', 'rigthudo', 'iOolu1XLWk', '高三2班'); INSERT INTO `t_student` VALUES (10041, '丁宇宁', 'xajjnxdn', '2OPHE1Xwdt', '高二1班'); INSERT INTO `t_student` VALUES (10042, '胡嘉伦', 'njybwilz', 'T4FyjyQ06G', '高二2班'); INSERT INTO `t_student` VALUES (10043, '孟岚', 'nvkvehrp', 'JkSNXREhIK', '高三2班'); INSERT INTO `t_student` VALUES (10044, '孟云熙', 'kkkpqfgs', 'PmdSsBaIVE', '高三2班'); INSERT INTO `t_student` VALUES (10045, '曹宇宁', 'falyiyal', 'LZruWY2x3D', '高二1班'); INSERT INTO `t_student` VALUES (10046, '陶睿', 'qyatgwvv', 'reKaYJZup4', '高三2班'); INSERT INTO `t_student` VALUES (10047, '程嘉伦', 'ytehfenv', 'xK2tx3HDDg', '高二1班'); INSERT INTO `t_student` VALUES (10048, '贺子韬', 'fwloybvz', '8qdM7vBgi6', '高三2班'); INSERT INTO `t_student` VALUES (10049, '石安琪', 'dcjajfyv', 'TT2kI3uUNK', '高三2班'); INSERT INTO `t_student` VALUES (10050, '贺岚', 'vqxzrdft', 'XE4wrXCITj', '高三2班'); -- ---------------------------- -- Table structure for t_video -- ---------------------------- DROP TABLE IF EXISTS `t_video`; CREATE TABLE `t_video` ( `vid` int(10) NOT NULL AUTO_INCREMENT, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`vid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10073 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_video -- ---------------------------- INSERT INTO `t_video` VALUES (10001, '10002', 'To successfully establish a new ', 'https://video.misgo.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10002, '10003', 'It is used while your ISPs do not ', 'http://video.fancm.us/ToysGames'); INSERT INTO `t_video` VALUES (10003, '10003', 'In other words, Navicat provides ', 'http://video.harada75.cn/Beauty'); INSERT INTO `t_video` VALUES (10004, '10002', 'It collects process metrics such ', 'http://video.kuliksun.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10005, '10003', 'Creativity is intelligence having fun.', 'https://video.waisanyam87.com/VideoGames'); INSERT INTO `t_video` VALUES (10006, '10002', 'Such sessions are also susceptible ', 'http://video.chin44.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10007, '10001', 'What you get by achieving your ', 'http://video.tanganqi.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10008, '10002', 'I will greet this day with love in my heart.', 'https://video.yinyunx.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10009, '10002', 'HTTP Tunneling is a method for ', 'http://video.fatl803.com/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10010, '10001', 'The first step is as good as half over. ', 'https://video.wuzhenn.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10011, '10003', 'To connect to a database or schema, ', 'http://video.lu15.xyz/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10012, '10001', 'The past has no power over the present moment.', 'http://video.burnsheather.info/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10013, '10001', 'It is used while your ISPs do not ', 'http://video.nts.com/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10014, '10001', 'The reason why a great man is great ', 'http://video.cheng1.xyz/Appliances'); INSERT INTO `t_video` VALUES (10015, '10003', 'The Main Window consists of several ', 'https://video.monicacraw5.info/HealthBabyCare'); INSERT INTO `t_video` VALUES (10016, '10001', 'The first step is as good as half over.', 'https://video.kinoshitahikaru1988.jp/Appliances'); INSERT INTO `t_video` VALUES (10017, '10002', 'In the Objects tab, you can use ', 'http://video.anoguchi.com/Others'); INSERT INTO `t_video` VALUES (10018, '10001', 'To start working with your server ', 'https://video.hicksjulie.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10019, '10003', 'The past has no power over the present moment.', 'https://video.sklo.org/FilmSupplies'); INSERT INTO `t_video` VALUES (10020, '10003', 'The On Startup feature allows you ', 'http://video.jijiang47.net/HealthBabyCare'); INSERT INTO `t_video` VALUES (10021, '10001', 'Navicat provides a wide range advanced ', 'http://video.linzita.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10022, '10002', 'The Information Pane shows the ', 'https://video.barnfr4.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10023, '10002', 'If it scares you, it might be a good thing to try.', 'https://video.shi704.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10024, '10001', 'Navicat Data Modeler is a powerful ', 'https://video.xu2015.xyz/VideoGames'); INSERT INTO `t_video` VALUES (10025, '10002', 'There is no way to happiness. Happiness ', 'http://video.suy.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10026, '10002', 'I will greet this day with love in my heart.', 'http://video.tang420.org/Baby'); INSERT INTO `t_video` VALUES (10027, '10003', 'In the middle of winter I at last ', 'https://video.xiy6.xyz/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10028, '10003', 'The Main Window consists of several ', 'https://video.jr59.jp/ComputersElectronics'); INSERT INTO `t_video` VALUES (10029, '10001', 'A query is used to extract data ', 'http://video.sakuroka1109.net/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10030, '10003', 'All journeys have secret destinations ', 'http://video.mmiyamoto.xyz/Appliances'); INSERT INTO `t_video` VALUES (10031, '10003', 'Navicat Monitor can be installed ', 'https://video.gard.com/CDsVinyl'); INSERT INTO `t_video` VALUES (10032, '10002', 'What you get by achieving your ', 'http://video.jefferywhi9.jp/AppsGames'); INSERT INTO `t_video` VALUES (10033, '10001', 'Navicat provides a wide range advanced ', 'http://video.ziyx2010.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10034, '10001', 'Optimism is the one quality more ', 'http://video.lxiu1.co.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10035, '10003', 'The On Startup feature allows you ', 'https://video.carmenhug.info/Baby'); INSERT INTO `t_video` VALUES (10036, '10002', 'The past has no power over the present moment.', 'http://video.cyuning.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10037, '10002', 'A man is not old until regrets ', 'http://video.yunxi84.co.jp/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10038, '10003', 'Secure Sockets Layer(SSL) is a ', 'http://video.jiechan.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10039, '10002', 'The Main Window consists of several ', 'https://video.randyspe.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10040, '10003', 'Navicat Monitor requires a repository ', 'https://video.kwokkn10.info/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10041, '10001', 'If the Show objects under schema ', 'https://video.okfan.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10042, '10003', 'To successfully establish a new ', 'https://video.liziyi.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10043, '10003', 'SQL Editor allows you to create ', 'http://video.kcharles.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10044, '10002', 'A man is not old until regrets ', 'http://video.sseiko.com/VideoGames'); INSERT INTO `t_video` VALUES (10045, '10001', 'If opportunity doesn’t knock, build a door.', 'http://video.ngkm.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10046, '10002', 'To successfully establish a new ', 'https://video.lsze.biz/MusicalInstrument'); INSERT INTO `t_video` VALUES (10047, '10002', 'I may not have gone where I intended ', 'http://video.whwu9.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10048, '10001', 'You will succeed because most people are lazy.', 'https://video.bh4.us/PetSupplies'); INSERT INTO `t_video` VALUES (10049, '10003', 'Actually it is just in an idea ', 'https://video.duanxia104.net/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10050, '10003', 'The reason why a great man is great ', 'https://video.zhennanwe.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10051, '10002', 'Navicat Monitor can be installed ', 'http://video.xiaoziyi.cn/Beauty'); INSERT INTO `t_video` VALUES (10052, '10003', 'I destroy my enemies when I make them my friends.', 'https://video.melissa506.us/Appliances'); INSERT INTO `t_video` VALUES (10053, '10003', 'I may not have gone where I intended ', 'http://video.colemb.co.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10054, '10001', 'Navicat provides powerful tools ', 'https://video.xiaomingli.com/Books'); INSERT INTO `t_video` VALUES (10055, '10002', 'Navicat Cloud provides a cloud ', 'http://video.cooperjuan803.biz/Appliances'); INSERT INTO `t_video` VALUES (10056, '10001', 'If your Internet Service Provider ', 'http://video.hiutung1025.co.jp/Food'); INSERT INTO `t_video` VALUES (10057, '10002', 'You can select any connections, ', 'http://video.kolu.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10058, '10003', 'SSH serves to prevent such vulnerabilities ', 'http://video.taniguchi727.com/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10059, '10003', 'There is no way to happiness. Happiness ', 'https://video.takedaminat67.net/AppsGames'); INSERT INTO `t_video` VALUES (10060, '10003', 'A query is used to extract data ', 'http://video.yunintang.jp/MusicalInstrument'); INSERT INTO `t_video` VALUES (10061, '10003', 'The Synchronize to Database function ', 'https://video.llu.biz/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10062, '10001', 'To open a query using an external ', 'http://video.yuen6.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10063, '10002', 'If the Show objects under schema ', 'http://video.huimeicho.biz/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10064, '10001', 'I destroy my enemies when I make them my friends.', 'http://video.yuitomori.cn/Beauty'); INSERT INTO `t_video` VALUES (10065, '10001', 'It provides strong authentication ', 'http://video.kondo1.biz/Others'); INSERT INTO `t_video` VALUES (10066, '10001', 'Typically, it is employed as an ', 'http://video.nantanaka10.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10067, '10001', 'Navicat Monitor can be installed ', 'http://video.konaoshi1.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10068, '10002', 'The past has no power over the present moment. ', 'http://video.yoshida205.cn/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10069, '10001', 'It provides strong authentication ', 'https://video.chiuwaiwan2.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10070, '10002', 'Typically, it is employed as an ', 'https://video.kwch.xyz/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10071, '10001', 'There is no way to happiness. Happiness ', 'https://video.daniels74.com/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10072, '10002', 'To connect to a database or schema, ', 'https://video.tinwingmak.co.jp/BaggageTravelEquipment'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题二/db_social.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_social Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 04/12/2023 15:10:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_friendship -- ---------------------------- DROP TABLE IF EXISTS `t_friendship`; CREATE TABLE `t_friendship` ( `fsid` int(10) NOT NULL AUTO_INCREMENT `uid` int(10) NULL DEFAULT NULL `fid` int(10) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`fsid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_friendship -- ---------------------------- INSERT INTO `t_friendship` VALUES (10001 10003 10009 '2002-04-04 01:50:50'); INSERT INTO `t_friendship` VALUES (10002 10012 10005 '2001-05-20 04:00:06'); INSERT INTO `t_friendship` VALUES (10003 10009 10004 '2010-12-19 01:07:49'); INSERT INTO `t_friendship` VALUES (10004 10008 10001 '2010-02-10 10:30:30'); INSERT INTO `t_friendship` VALUES (10005 10011 10013 '2014-03-30 01:38:33'); INSERT INTO `t_friendship` VALUES (10006 10001 10020 '2007-10-08 17:28:48'); INSERT INTO `t_friendship` VALUES (10007 10019 10009 '2007-12-06 23:26:42'); INSERT INTO `t_friendship` VALUES (10008 10010 10016 '2005-03-21 12:18:51'); INSERT INTO `t_friendship` VALUES (10009 10007 10017 '2016-06-15 04:52:59'); INSERT INTO `t_friendship` VALUES (10010 10014 10004 '2007-10-26 09:36:32'); INSERT INTO `t_friendship` VALUES (10011 10018 10011 '2019-04-05 20:55:26'); INSERT INTO `t_friendship` VALUES (10012 10020 10003 '2017-03-25 13:46:34'); INSERT INTO `t_friendship` VALUES (10013 10006 10006 '2019-12-08 01:28:33'); INSERT INTO `t_friendship` VALUES (10014 10005 10014 '2000-01-30 13:45:26'); INSERT INTO `t_friendship` VALUES (10015 10017 10012 '2010-07-06 23:56:41'); INSERT INTO `t_friendship` VALUES (10016 10002 10001 '2003-11-18 02:35:48'); INSERT INTO `t_friendship` VALUES (10017 10013 10003 '2004-09-26 06:30:19'); INSERT INTO `t_friendship` VALUES (10018 10016 10013 '2016-05-06 21:42:34'); INSERT INTO `t_friendship` VALUES (10019 10004 10018 '2016-07-22 16:42:12'); INSERT INTO `t_friendship` VALUES (10020 10015 10002 '2008-08-13 11:52:14'); INSERT INTO `t_friendship` VALUES (10021 10019 10010 '2019-10-19 05:15:00'); INSERT INTO `t_friendship` VALUES (10022 10019 10017 '2015-05-17 23:29:15'); INSERT INTO `t_friendship` VALUES (10023 10018 10013 '2002-02-04 14:25:32'); INSERT INTO `t_friendship` VALUES (10024 10002 10014 '2003-05-29 06:46:36'); INSERT INTO `t_friendship` VALUES (10025 10002 10001 '2012-09-05 06:09:52'); INSERT INTO `t_friendship` VALUES (10026 10015 10016 '2019-09-21 07:11:07'); INSERT INTO `t_friendship` VALUES (10027 10010 10006 '2001-08-04 13:09:40'); INSERT INTO `t_friendship` VALUES (10028 10008 10002 '2000-05-03 01:46:48'); INSERT INTO `t_friendship` VALUES (10029 10011 10010 '2023-05-13 10:03:10'); INSERT INTO `t_friendship` VALUES (10030 10015 10010 '2023-09-18 12:05:18'); INSERT INTO `t_friendship` VALUES (10031 10003 10010 '2023-10-14 10:58:49'); INSERT INTO `t_friendship` VALUES (10032 10017 10020 '2014-01-03 07:56:10'); INSERT INTO `t_friendship` VALUES (10033 10013 10008 '2002-06-10 13:18:22'); INSERT INTO `t_friendship` VALUES (10034 10012 10011 '2004-04-26 00:18:56'); INSERT INTO `t_friendship` VALUES (10035 10017 10016 '2015-02-03 02:01:15'); INSERT INTO `t_friendship` VALUES (10036 10009 10006 '2014-04-09 05:30:28'); INSERT INTO `t_friendship` VALUES (10037 10005 10004 '2013-02-10 07:48:18'); INSERT INTO `t_friendship` VALUES (10038 10013 10020 '2022-03-03 18:35:47'); INSERT INTO `t_friendship` VALUES (10039 10020 10010 '2021-01-11 01:13:43'); INSERT INTO `t_friendship` VALUES (10040 10009 10010 '2015-11-24 22:22:40'); INSERT INTO `t_friendship` VALUES (10041 10004 10013 '2000-06-27 13:32:43'); INSERT INTO `t_friendship` VALUES (10042 10011 10002 '2020-02-01 05:44:39'); INSERT INTO `t_friendship` VALUES (10043 10018 10006 '2011-01-01 09:56:26'); INSERT INTO `t_friendship` VALUES (10044 10005 10014 '2015-02-26 02:27:57'); INSERT INTO `t_friendship` VALUES (10045 10008 10004 '2011-06-30 04:45:03'); INSERT INTO `t_friendship` VALUES (10046 10010 10013 '2013-08-22 02:37:54'); INSERT INTO `t_friendship` VALUES (10047 10001 10003 '2006-08-28 16:12:09'); INSERT INTO `t_friendship` VALUES (10048 10016 10011 '2022-03-22 03:48:39'); INSERT INTO `t_friendship` VALUES (10049 10014 10012 '2022-05-09 05:44:28'); INSERT INTO `t_friendship` VALUES (10050 10006 10002 '2020-01-06 03:24:32'); -- ---------------------------- -- Table structure for t_likes -- ---------------------------- DROP TABLE IF EXISTS `t_likes`; CREATE TABLE `t_likes` ( `lid` int(10) NOT NULL AUTO_INCREMENT `pid` int(11) NULL DEFAULT NULL `fid` int(11) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_likes -- ---------------------------- INSERT INTO `t_likes` VALUES (10001 10032 10017 '2001-10-04 21:44:01'); INSERT INTO `t_likes` VALUES (10002 10023 10001 '2022-02-18 08:37:36'); INSERT INTO `t_likes` VALUES (10003 10009 10016 '2003-07-23 17:16:43'); INSERT INTO `t_likes` VALUES (10004 10008 10013 '2008-06-02 00:36:15'); INSERT INTO `t_likes` VALUES (10005 10011 10008 '2023-11-20 20:30:02'); INSERT INTO `t_likes` VALUES (10006 10041 10003 '2003-08-09 18:06:15'); INSERT INTO `t_likes` VALUES (10007 10026 10012 '2015-08-14 16:05:12'); INSERT INTO `t_likes` VALUES (10008 10044 10002 '2012-02-17 16:58:03'); INSERT INTO `t_likes` VALUES (10009 10038 10004 '2008-07-25 03:46:02'); INSERT INTO `t_likes` VALUES (10010 10015 10005 '2004-03-03 04:12:39'); INSERT INTO `t_likes` VALUES (10011 10047 10014 '2005-08-03 16:55:45'); INSERT INTO `t_likes` VALUES (10012 10007 10009 '2013-10-27 14:55:15'); INSERT INTO `t_likes` VALUES (10013 10027 10007 '2010-03-09 15:35:03'); INSERT INTO `t_likes` VALUES (10014 10025 10019 '2015-02-11 10:27:53'); INSERT INTO `t_likes` VALUES (10015 10022 10018 '2010-07-18 18:07:15'); INSERT INTO `t_likes` VALUES (10016 10018 10006 '2014-05-15 22:12:11'); INSERT INTO `t_likes` VALUES (10017 10045 10015 '2005-11-04 15:59:38'); INSERT INTO `t_likes` VALUES (10018 10033 10011 '2005-12-22 05:47:18'); INSERT INTO `t_likes` VALUES (10019 10001 10010 '2015-10-08 04:53:15'); INSERT INTO `t_likes` VALUES (10020 10017 10020 '2009-05-13 13:46:05'); INSERT INTO `t_likes` VALUES (10021 10019 10008 '2002-06-26 21:34:07'); INSERT INTO `t_likes` VALUES (10022 10016 10002 '2005-06-29 14:02:06'); INSERT INTO `t_likes` VALUES (10023 10003 10017 '2003-12-22 10:50:10'); INSERT INTO `t_likes` VALUES (10024 10021 10011 '2019-07-14 18:23:10'); INSERT INTO `t_likes` VALUES (10025 10034 10018 '2019-11-28 02:18:34'); INSERT INTO `t_likes` VALUES (10026 10006 10013 '2003-04-08 16:16:39'); INSERT INTO `t_likes` VALUES (10027 10048 10009 '2023-01-06 06:36:19'); INSERT INTO `t_likes` VALUES (10028 10042 10013 '2013-07-13 11:11:06'); INSERT INTO `t_likes` VALUES (10029 10036 10002 '2015-04-30 14:41:42'); INSERT INTO `t_likes` VALUES (10030 10002 10007 '2012-02-29 09:33:42'); INSERT INTO `t_likes` VALUES (10031 10037 10019 '2007-07-31 03:46:45'); INSERT INTO `t_likes` VALUES (10032 10029 10008 '2003-10-27 16:27:50'); INSERT INTO `t_likes` VALUES (10033 10012 10014 '2009-01-26 02:43:55'); INSERT INTO `t_likes` VALUES (10034 10030 10018 '2016-07-12 13:31:24'); INSERT INTO `t_likes` VALUES (10035 10035 10017 '2000-01-25 02:43:04'); INSERT INTO `t_likes` VALUES (10036 10028 10019 '2019-01-04 21:35:33'); INSERT INTO `t_likes` VALUES (10037 10031 10008 '2006-04-21 08:35:30'); INSERT INTO `t_likes` VALUES (10038 10049 10017 '2000-07-26 06:08:06'); INSERT INTO `t_likes` VALUES (10039 10004 10009 '2023-09-05 15:22:10'); INSERT INTO `t_likes` VALUES (10040 10043 10001 '2015-03-26 15:54:46'); INSERT INTO `t_likes` VALUES (10041 10005 10014 '2015-05-21 02:43:43'); INSERT INTO `t_likes` VALUES (10042 10046 10013 '2018-04-28 11:35:59'); INSERT INTO `t_likes` VALUES (10043 10024 10020 '2020-12-30 04:43:22'); INSERT INTO `t_likes` VALUES (10044 10050 10006 '2015-12-27 07:07:00'); INSERT INTO `t_likes` VALUES (10045 10014 10002 '2001-07-12 09:10:50'); INSERT INTO `t_likes` VALUES (10046 10040 10001 '2013-08-12 19:47:56'); INSERT INTO `t_likes` VALUES (10047 10039 10003 '2003-04-08 16:00:47'); INSERT INTO `t_likes` VALUES (10048 10013 10010 '2009-02-21 01:51:41'); INSERT INTO `t_likes` VALUES (10049 10010 10017 '2009-06-22 17:34:07'); INSERT INTO `t_likes` VALUES (10050 10020 10004 '2019-10-24 00:30:07'); INSERT INTO `t_likes` VALUES (10051 10037 10009 '2017-01-26 15:41:20'); INSERT INTO `t_likes` VALUES (10052 10019 10010 '2004-03-05 07:49:17'); INSERT INTO `t_likes` VALUES (10053 10024 10007 '2003-08-12 01:06:49'); INSERT INTO `t_likes` VALUES (10054 10018 10015 '2009-11-15 17:25:31'); INSERT INTO `t_likes` VALUES (10055 10011 10019 '2008-08-31 14:41:22'); INSERT INTO `t_likes` VALUES (10056 10027 10004 '2021-07-30 12:50:58'); INSERT INTO `t_likes` VALUES (10057 10040 10012 '2009-06-18 03:32:59'); INSERT INTO `t_likes` VALUES (10058 10041 10011 '2005-07-15 08:40:49'); INSERT INTO `t_likes` VALUES (10059 10027 10001 '2023-11-03 00:16:59'); INSERT INTO `t_likes` VALUES (10060 10017 10003 '2022-01-09 05:57:27'); INSERT INTO `t_likes` VALUES (10061 10025 10005 '2003-02-11 00:42:46'); INSERT INTO `t_likes` VALUES (10062 10021 10004 '2016-07-31 05:26:24'); INSERT INTO `t_likes` VALUES (10063 10036 10012 '2005-02-21 01:16:20'); INSERT INTO `t_likes` VALUES (10064 10017 10019 '2023-01-30 23:58:39'); INSERT INTO `t_likes` VALUES (10065 10026 10013 '2022-08-03 04:41:12'); INSERT INTO `t_likes` VALUES (10066 10007 10014 '2004-02-06 13:25:20'); INSERT INTO `t_likes` VALUES (10067 10007 10018 '2023-10-29 12:47:27'); INSERT INTO `t_likes` VALUES (10068 10039 10020 '2016-09-27 15:00:18'); INSERT INTO `t_likes` VALUES (10069 10046 10015 '2015-05-06 03:39:44'); INSERT INTO `t_likes` VALUES (10070 10002 10007 '2016-02-05 05:48:52'); INSERT INTO `t_likes` VALUES (10071 10047 10002 '2015-03-18 13:22:58'); INSERT INTO `t_likes` VALUES (10072 10021 10011 '2002-12-21 21:16:38'); INSERT INTO `t_likes` VALUES (10073 10040 10017 '2018-01-28 02:31:12'); INSERT INTO `t_likes` VALUES (10074 10050 10008 '2022-12-27 15:45:29'); INSERT INTO `t_likes` VALUES (10075 10005 10010 '2010-10-12 06:34:09'); INSERT INTO `t_likes` VALUES (10076 10050 10002 '2021-08-21 22:27:44'); INSERT INTO `t_likes` VALUES (10077 10044 10017 '2004-04-07 10:52:28'); INSERT INTO `t_likes` VALUES (10078 10030 10015 '2013-07-11 19:36:53'); INSERT INTO `t_likes` VALUES (10079 10010 10008 '2018-09-07 11:29:25'); INSERT INTO `t_likes` VALUES (10080 10014 10006 '2002-01-31 00:05:49'); INSERT INTO `t_likes` VALUES (10081 10011 10010 '2021-10-19 00:55:37'); INSERT INTO `t_likes` VALUES (10082 10018 10016 '2000-03-10 09:20:16'); INSERT INTO `t_likes` VALUES (10083 10012 10007 '2009-03-22 19:06:25'); INSERT INTO `t_likes` VALUES (10084 10006 10009 '2016-09-18 14:11:18'); INSERT INTO `t_likes` VALUES (10085 10008 10012 '2010-11-20 08:14:55'); INSERT INTO `t_likes` VALUES (10086 10043 10004 '2008-02-27 12:30:05'); INSERT INTO `t_likes` VALUES (10087 10030 10003 '2000-03-29 07:18:02'); INSERT INTO `t_likes` VALUES (10088 10026 10018 '2016-02-23 23:15:54'); INSERT INTO `t_likes` VALUES (10089 10048 10017 '2006-10-05 01:59:59'); INSERT INTO `t_likes` VALUES (10090 10044 10008 '2020-09-09 00:03:47'); INSERT INTO `t_likes` VALUES (10091 10008 10018 '2020-08-29 18:22:05'); INSERT INTO `t_likes` VALUES (10092 10009 10012 '2019-10-31 01:59:48'); INSERT INTO `t_likes` VALUES (10093 10025 10013 '2011-03-16 13:02:56'); INSERT INTO `t_likes` VALUES (10094 10043 10006 '2023-10-22 19:31:52'); INSERT INTO `t_likes` VALUES (10095 10001 10020 '2011-07-23 22:21:20'); INSERT INTO `t_likes` VALUES (10096 10034 10008 '2006-11-08 11:59:44'); INSERT INTO `t_likes` VALUES (10097 10024 10003 '2021-04-06 01:14:15'); INSERT INTO `t_likes` VALUES (10098 10039 10014 '2019-06-16 04:55:10'); INSERT INTO `t_likes` VALUES (10099 10032 10001 '2007-11-02 19:19:16'); INSERT INTO `t_likes` VALUES (10100 10029 10020 '2014-02-04 05:11:29'); -- ---------------------------- -- Table structure for t_post -- ---------------------------- DROP TABLE IF EXISTS `t_post`; CREATE TABLE `t_post` ( `pid` int(10) NOT NULL AUTO_INCREMENT `uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `createtime` date NULL DEFAULT NULL PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_post -- ---------------------------- INSERT INTO `t_post` VALUES (10001 '10003' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab.' '2020-10-04'); INSERT INTO `t_post` VALUES (10002 '10006' 'You will succeed because most people are lazy. Creativity is intelligence having fun. The Main Window consists of several toolbars and panes for you to work on connections database objects and advanced tools.' '2014-07-10'); INSERT INTO `t_post` VALUES (10003 '10011' 'Flexible settings enable you to set up a custom key for comparison and synchronization. The first step is as good as half over. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port ' '2007-06-05'); INSERT INTO `t_post` VALUES (10004 '10002' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information. SSH serves to prevent such vulnerabilities ' '2000-03-20'); INSERT INTO `t_post` VALUES (10005 '10019' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed ' '2021-05-19'); INSERT INTO `t_post` VALUES (10006 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2013-07-27'); INSERT INTO `t_post` VALUES (10007 '10012' 'You must be the change you wish to see in the world. Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords ' '2016-05-17'); INSERT INTO `t_post` VALUES (10008 '10010' 'It is used while your ISPs do not allow direct connections but allows establishing HTTP connections. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Instead of wondering when your next vacation ' '2013-06-26'); INSERT INTO `t_post` VALUES (10009 '10017' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2014-03-09'); INSERT INTO `t_post` VALUES (10010 '10018' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Cloud provides a cloud service for synchronizing connections queries model files and virtual group information ' '2017-08-24'); INSERT INTO `t_post` VALUES (10011 '10008' 'Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. If you wait all that happens is you get older.' '2013-01-01'); INSERT INTO `t_post` VALUES (10012 '10007' 'You cannot save people you can just love them. Typically it is employed as an encrypted version of Telnet. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up ' '2015-12-09'); INSERT INTO `t_post` VALUES (10013 '10001' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If your Internet Service Provider (ISP) does not provide direct access to its server Secure ' '2007-04-07'); INSERT INTO `t_post` VALUES (10014 '10020' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Champions keep playing until they get it right. Navicat 15 has added support for the system-wide dark mode.' '2012-01-31'); INSERT INTO `t_post` VALUES (10015 '10014' 'A man’s best friends are his ten fingers. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. What you get by achieving your goals is not as ' '2015-01-04'); INSERT INTO `t_post` VALUES (10016 '10015' 'Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or MongoDB databases making database administration to multiple kinds of database so easy.' '2013-08-24'); INSERT INTO `t_post` VALUES (10017 '10016' 'Actually it is just in an idea when feel oneself can achieve and cannot achieve. A man is not old until regrets take the place of dreams.' '2008-07-11'); INSERT INTO `t_post` VALUES (10018 '10013' 'The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles and preview.' '2006-12-28'); INSERT INTO `t_post` VALUES (10019 '10004' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2013-07-30'); INSERT INTO `t_post` VALUES (10020 '10005' 'HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. A man is not old until regrets take the place of dreams.' '2023-09-01'); INSERT INTO `t_post` VALUES (10021 '10007' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. There is no way to happiness. Happiness is the way. The reason why a great man is great is that he resolves to be a great man.' '2018-01-18'); INSERT INTO `t_post` VALUES (10022 '10006' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration.' '2001-11-07'); INSERT INTO `t_post` VALUES (10023 '10019' 'Genius is an infinite capacity for taking pains. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2022-04-06'); INSERT INTO `t_post` VALUES (10024 '10012' 'If your Internet Service Provider (ISP) does not provide direct access to its server Secure Tunneling Protocol (SSH) / HTTP is another solution. What you get by achieving your goals is not as important as what you become by achieving your goals.' '2002-07-07'); INSERT INTO `t_post` VALUES (10025 '10014' 'If you wait all that happens is you get older. With its well-designed Graphical User Interface(GUI) Navicat lets you quickly and easily create organize access and share information in a secure and easy way.' '2004-06-25'); INSERT INTO `t_post` VALUES (10026 '10004' 'To clear or reload various internal caches flush tables or acquire locks control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature.' '2004-05-09'); INSERT INTO `t_post` VALUES (10027 '10005' 'I may not have gone where I intended to go but I think I have ended up where I needed to be. A comfort zone is a beautiful place but nothing ever grows there.' '2003-08-15'); INSERT INTO `t_post` VALUES (10028 '10006' 'Champions keep playing until they get it right. Remember that failure is an event not a person. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual logical and physical data models.' '2016-10-28'); INSERT INTO `t_post` VALUES (10029 '10010' 'What you get by achieving your goals is not as important as what you become by achieving your goals. After logged in the Navicat Cloud feature the Navigation pane will be divided into Navicat Cloud and My Connections sections.' '2021-10-29'); INSERT INTO `t_post` VALUES (10030 '10014' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If the Show objects under schema in navigation pane option is checked at the Preferences ' '2007-03-17'); INSERT INTO `t_post` VALUES (10031 '10001' 'If it scares you it might be a good thing to try. I destroy my enemies when I make them my friends. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does.' '2005-12-06'); INSERT INTO `t_post` VALUES (10032 '10019' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Monitor requires a repository to store alerts and metrics for historical analysis.' '2014-12-11'); INSERT INTO `t_post` VALUES (10033 '10018' 'Creativity is intelligence having fun. I destroy my enemies when I make them my friends. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or ' '2017-03-22'); INSERT INTO `t_post` VALUES (10034 '10012' 'To connect to a database or schema simply double-click it in the pane. Flexible settings enable you to set up a custom key for comparison and synchronization. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2022-11-13'); INSERT INTO `t_post` VALUES (10035 '10017' 'If the Show objects under schema in navigation pane option is checked at the Preferences window all database objects are also displayed in the pane. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. ' '2012-02-23'); INSERT INTO `t_post` VALUES (10036 '10008' 'Optimism is the one quality more associated with success and happiness than any other. A query is used to extract data from the database in a readable format according to the user\'s request.' '2005-12-16'); INSERT INTO `t_post` VALUES (10037 '10002' 'The past has no power over the present moment. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored.' '2016-04-13'); INSERT INTO `t_post` VALUES (10038 '10010' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. It collects process metrics such as CPU load RAM usage and a variety of other resources over SSH/SNMP.' '2010-10-20'); INSERT INTO `t_post` VALUES (10039 '10003' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network.' '2019-07-20'); INSERT INTO `t_post` VALUES (10040 '10020' 'Optimism is the one quality more associated with success and happiness than any other. In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session ' '2003-11-25'); INSERT INTO `t_post` VALUES (10041 '10007' 'Creativity is intelligence having fun. A comfort zone is a beautiful place but nothing ever grows there. After comparing data the window shows the number of records that will be inserted updated or deleted in the target.' '2003-03-21'); INSERT INTO `t_post` VALUES (10042 '10001' 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Genius is an infinite capacity for taking pains. Anyone who has ever made anything of importance was disciplined.' '2000-03-30'); INSERT INTO `t_post` VALUES (10043 '10002' 'Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet.' '2013-12-21'); INSERT INTO `t_post` VALUES (10044 '10016' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information.' '2016-03-25'); INSERT INTO `t_post` VALUES (10045 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2004-03-05'); INSERT INTO `t_post` VALUES (10046 '10017' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network. How we spend our days is of course how we spend our lives. I may not have gone ' '2015-07-06'); INSERT INTO `t_post` VALUES (10047 '10013' 'Navicat Monitor requires a repository to store alerts and metrics for historical analysis. The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles ' '2016-09-13'); INSERT INTO `t_post` VALUES (10048 '10016' 'Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2005-01-10'); INSERT INTO `t_post` VALUES (10049 '10020' 'You cannot save people you can just love them. The On Startup feature allows you to control what tabs appear when you launch Navicat. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2010-05-16'); INSERT INTO `t_post` VALUES (10050 '10015' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2004-04-21'); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `uid` int(10) NOT NULL AUTO_INCREMENT `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `age` int(3) NULL DEFAULT NULL `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL PRIMARY KEY (`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (10001 'RcZMBygzEP' 'KAc0k5N7ik' 'Kimberly' 31 '女'); INSERT INTO `t_user` VALUES (10002 'xZbFVNFPfC' 'YGQPYvApoW' 'Betty' 19 '女'); INSERT INTO `t_user` VALUES (10003 'rWQkglfDHp' 'a090zWktf2' 'Barry' 43 'ç”·'); INSERT INTO `t_user` VALUES (10004 'AsWnNuQrBn' 'AzS6Fiv4TD' 'Randy' 49 'ç”·'); INSERT INTO `t_user` VALUES (10005 'ydPZCqwaWz' 'SwOjHxNc29' 'Amy' 30 '女'); INSERT INTO `t_user` VALUES (10006 'egikGPKoHB' '0IyNHa4ACw' 'Ruth' 33 '女'); INSERT INTO `t_user` VALUES (10007 'AWxdiAksDt' 'j6vFisZKc1' 'April' 38 '女'); INSERT INTO `t_user` VALUES (10008 'aUTVurILei' 'bPxFeeKhy8' 'Cynthia' 38 '女'); INSERT INTO `t_user` VALUES (10009 'RcOgLMMata' 'AxhUsVUU78' 'Tammy' 20 '女'); INSERT INTO `t_user` VALUES (10010 'iRnxECjbol' 'QCfHAiimrG' 'Alice' 15 '女'); INSERT INTO `t_user` VALUES (10011 'FhqYITqTdA' 'dVNCEepBKC' 'Thelma' 46 '女'); INSERT INTO `t_user` VALUES (10012 'hBFObiRjOn' 'qoKKRgbYzO' 'Bradley' 27 'ç”·'); INSERT INTO `t_user` VALUES (10013 'nOLwlDpyIN' 'tGuW0T5FcG' 'Jean' 28 '女'); INSERT INTO `t_user` VALUES (10014 'VYhKLehGcy' 'phKBleXEQ9' 'Jose' 44 'ç”·'); INSERT INTO `t_user` VALUES (10015 'ybKBizSikJ' 'l7sRDLObVU' 'Daniel' 48 'ç”·'); INSERT INTO `t_user` VALUES (10016 'uvOZOdSvbV' 'eYmVqLJm3z' 'Rosa' 22 '女'); INSERT INTO `t_user` VALUES (10017 'OHZBeflocp' '8O8DZeCB9R' 'Tony' 44 'ç”·'); INSERT INTO `t_user` VALUES (10018 'gHfroIcoQc' '63USEuGBeB' 'Thomas' 16 'ç”·'); INSERT INTO `t_user` VALUES (10019 'HRQGdchgoS' 'apvalUkIbQ' 'Kelly' 17 '女'); INSERT INTO `t_user` VALUES (10020 'tBFVIvbDgj' 'IwcjzMg9xB' 'Steven' 33 'ç”·'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《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: 05/12/2023 10:57:18 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_doctor -- ---------------------------- DROP TABLE IF EXISTS `t_doctor`; CREATE TABLE `t_doctor` ( `did` int(10) NOT NULL AUTO_INCREMENT, `dname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `office` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`did`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_doctor -- ---------------------------- INSERT INTO `t_doctor` VALUES (10001, '孟睿', '外科', '实习医生', '196-1142-8607'); INSERT INTO `t_doctor` VALUES (10002, '孙云熙', '耳鼻喉科', '实习医生', '133-0211-7241'); INSERT INTO `t_doctor` VALUES (10003, '邹岚', '内科', '高级医生', '10-560-1386'); INSERT INTO `t_doctor` VALUES (10004, '周子异', '外科', '实习医生', '199-8805-8963'); INSERT INTO `t_doctor` VALUES (10005, '朱睿', '外科', '中级医生', '191-5127-0466'); INSERT INTO `t_doctor` VALUES (10006, '常安琪', '耳鼻喉科', '实习医生', '755-780-8243'); INSERT INTO `t_doctor` VALUES (10007, '崔秀英', '儿科', '主任', '186-1296-4216'); INSERT INTO `t_doctor` VALUES (10008, '董詩涵', '外科', '主任', '760-5492-7849'); INSERT INTO `t_doctor` VALUES (10009, '崔秀英', '内科', '中级医生', '10-1750-7240'); INSERT INTO `t_doctor` VALUES (10010, '周睿', '耳鼻喉科', '高级医生', '755-834-7691'); INSERT INTO `t_doctor` VALUES (10011, '卢震南', '儿科', '中级医生', '186-5900-0614'); INSERT INTO `t_doctor` VALUES (10012, '雷震南', '耳鼻喉科', '高级医生', '178-6511-9350'); INSERT INTO `t_doctor` VALUES (10013, '雷岚', '儿科', '实习医生', '190-6306-4361'); INSERT INTO `t_doctor` VALUES (10014, '唐云熙', '内科', '中级医生', '755-0855-7704'); INSERT INTO `t_doctor` VALUES (10015, '郑震南', '儿科', '中级医生', '20-8721-5863'); INSERT INTO `t_doctor` VALUES (10016, '贾杰宏', '内科', '主任', '130-1162-3953'); INSERT INTO `t_doctor` VALUES (10017, '任睿', '耳鼻喉科', '主任', '21-4613-2793'); INSERT INTO `t_doctor` VALUES (10018, '侯安琪', '内科', '中级医生', '769-867-7575'); INSERT INTO `t_doctor` VALUES (10019, '郝杰宏', '儿科', '实习医生', '21-638-0661'); INSERT INTO `t_doctor` VALUES (10020, '秦晓明', '内科', '中级医生', '178-0882-6094'); -- ---------------------------- -- Table structure for t_patient -- ---------------------------- DROP TABLE IF EXISTS `t_patient`; CREATE TABLE `t_patient` ( `pid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(5) NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_patient -- ---------------------------- INSERT INTO `t_patient` VALUES ('10001', '严子韬', '男', 30, '178-8729-5799'); INSERT INTO `t_patient` VALUES ('10002', '蔡詩涵', '女', 17, '755-6590-9717'); INSERT INTO `t_patient` VALUES ('10003', '蔡嘉伦', '男', 31, '147-0244-7071'); INSERT INTO `t_patient` VALUES ('10004', '卢安琪', '女', 19, '28-018-1654'); INSERT INTO `t_patient` VALUES ('10005', '许宇宁', '男', 57, '139-8471-7072'); INSERT INTO `t_patient` VALUES ('10006', '彭璐', '女', 56, '144-0250-4252'); INSERT INTO `t_patient` VALUES ('10007', '李睿', '男', 11, '760-5963-6579'); INSERT INTO `t_patient` VALUES ('10008', '叶宇宁', '男', 33, '155-1117-9875'); INSERT INTO `t_patient` VALUES ('10009', '杨睿', '男', 48, '760-1389-9772'); INSERT INTO `t_patient` VALUES ('10010', '熊致远', '男', 11, '20-9278-7287'); INSERT INTO `t_patient` VALUES ('10011', '谭子韬', '男', 11, '10-5460-3302'); INSERT INTO `t_patient` VALUES ('10012', '龙云熙', '男', 36, '769-625-8369'); INSERT INTO `t_patient` VALUES ('10013', '潘睿', '男', 15, '146-5460-0503'); INSERT INTO `t_patient` VALUES ('10014', '胡嘉伦', '男', 23, '144-0725-3728'); INSERT INTO `t_patient` VALUES ('10015', '陶睿', '男', 50, '144-4354-4812'); INSERT INTO `t_patient` VALUES ('10016', '顾震南', '男', 33, '755-837-7148'); INSERT INTO `t_patient` VALUES ('10017', '袁岚', '女', 49, '173-5836-5107'); INSERT INTO `t_patient` VALUES ('10018', '卢詩涵', '女', 58, '760-176-4450'); INSERT INTO `t_patient` VALUES ('10019', '李璐', '女', 22, '20-8392-9908'); INSERT INTO `t_patient` VALUES ('10020', '蔡詩涵', '女', 27, '190-8099-9579'); INSERT INTO `t_patient` VALUES ('10021', '吕子异', '男', 23, '28-205-6374'); INSERT INTO `t_patient` VALUES ('10022', '侯詩涵', '女', 25, '20-4328-8586'); INSERT INTO `t_patient` VALUES ('10023', '孔睿', '男', 58, '769-118-9579'); INSERT INTO `t_patient` VALUES ('10024', '徐嘉伦', '男', 33, '21-0131-1452'); INSERT INTO `t_patient` VALUES ('10025', '傅安琪', '女', 17, '760-074-2030'); INSERT INTO `t_patient` VALUES ('10026', '蒋致远', '男', 49, '154-1502-8322'); INSERT INTO `t_patient` VALUES ('10027', '何云熙', '男', 11, '760-7767-9468'); INSERT INTO `t_patient` VALUES ('10028', '朱秀英', '女', 57, '28-951-6412'); INSERT INTO `t_patient` VALUES ('10029', '萧睿', '男', 16, '169-1837-9488'); INSERT INTO `t_patient` VALUES ('10030', '苏宇宁', '男', 28, '769-6418-4954'); INSERT INTO `t_patient` VALUES ('10031', '马睿', '男', 44, '21-868-2371'); INSERT INTO `t_patient` VALUES ('10032', '吴晓明', '男', 46, '138-8679-0662'); INSERT INTO `t_patient` VALUES ('10033', '汪震南', '男', 55, '156-1029-5325'); INSERT INTO `t_patient` VALUES ('10034', '陆嘉伦', '男', 12, '755-081-8243'); INSERT INTO `t_patient` VALUES ('10035', '韩致远', '男', 14, '28-3673-8413'); INSERT INTO `t_patient` VALUES ('10036', '陶詩涵', '女', 42, '185-8722-8093'); INSERT INTO `t_patient` VALUES ('10037', '秦璐', '女', 60, '769-275-5209'); INSERT INTO `t_patient` VALUES ('10038', '余致远', '男', 20, '179-1132-3645'); INSERT INTO `t_patient` VALUES ('10039', '梁云熙', '男', 39, '21-7784-6260'); INSERT INTO `t_patient` VALUES ('10040', '刘晓明', '男', 50, '143-5309-6600'); INSERT INTO `t_patient` VALUES ('10041', '贺杰宏', '男', 14, '760-9388-2272'); INSERT INTO `t_patient` VALUES ('10042', '廖子异', '男', 54, '10-700-0511'); INSERT INTO `t_patient` VALUES ('10043', '邵致远', '男', 45, '769-970-5598'); INSERT INTO `t_patient` VALUES ('10044', '常子韬', '男', 44, '142-2894-9338'); INSERT INTO `t_patient` VALUES ('10045', '龚睿', '男', 42, '760-8312-1246'); INSERT INTO `t_patient` VALUES ('10046', '雷秀英', '女', 34, '755-2071-2097'); INSERT INTO `t_patient` VALUES ('10047', '钟晓明', '男', 55, '769-301-9665'); INSERT INTO `t_patient` VALUES ('10048', '黎致远', '男', 39, '20-9401-0460'); INSERT INTO `t_patient` VALUES ('10049', '马杰宏', '男', 44, '142-4147-4122'); INSERT INTO `t_patient` VALUES ('10050', '魏云熙', '男', 35, '21-6786-3131'); -- ---------------------------- -- Table structure for t_registration -- ---------------------------- DROP TABLE IF EXISTS `t_registration`; CREATE TABLE `t_registration` ( `rid` int(10) NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL, `did` int(10) NULL DEFAULT NULL, `rtime` date NULL DEFAULT NULL, PRIMARY KEY (`rid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 490051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_registration -- ---------------------------- INSERT INTO `t_registration` VALUES (1, 10007, 10001, '2006-12-31'); INSERT INTO `t_registration` VALUES (10002, 10049, 10011, '2017-07-12'); INSERT INTO `t_registration` VALUES (20003, 10037, 10013, '2004-05-08'); INSERT INTO `t_registration` VALUES (30004, 10005, 10018, '2001-02-22'); INSERT INTO `t_registration` VALUES (40005, 10039, 10015, '2021-04-24'); INSERT INTO `t_registration` VALUES (50006, 10011, 10011, '2019-05-11'); INSERT INTO `t_registration` VALUES (60007, 10035, 10002, '2010-02-10'); INSERT INTO `t_registration` VALUES (70008, 10018, 10005, '2000-03-18'); INSERT INTO `t_registration` VALUES (80009, 10032, 10005, '2021-04-01'); INSERT INTO `t_registration` VALUES (90010, 10034, 10009, '2007-03-04'); INSERT INTO `t_registration` VALUES (100011, 10014, 10013, '2022-12-28'); INSERT INTO `t_registration` VALUES (110012, 10026, 10015, '2018-04-25'); INSERT INTO `t_registration` VALUES (120013, 10009, 10019, '2011-09-05'); INSERT INTO `t_registration` VALUES (130014, 10021, 10007, '2015-09-24'); INSERT INTO `t_registration` VALUES (140015, 10020, 10004, '2013-10-02'); INSERT INTO `t_registration` VALUES (150016, 10013, 10009, '2016-11-15'); INSERT INTO `t_registration` VALUES (160017, 10038, 10013, '2018-10-03'); INSERT INTO `t_registration` VALUES (170018, 10044, 10012, '2018-03-07'); INSERT INTO `t_registration` VALUES (180019, 10048, 10003, '2004-08-09'); INSERT INTO `t_registration` VALUES (190020, 10043, 10012, '2017-05-18'); INSERT INTO `t_registration` VALUES (200021, 10016, 10017, '2011-10-07'); INSERT INTO `t_registration` VALUES (210022, 10012, 10005, '2005-12-14'); INSERT INTO `t_registration` VALUES (220023, 10010, 10004, '2018-07-20'); INSERT INTO `t_registration` VALUES (230024, 10002, 10011, '2023-11-06'); INSERT INTO `t_registration` VALUES (240025, 10017, 10010, '2016-11-26'); INSERT INTO `t_registration` VALUES (250026, 10033, 10011, '2004-12-03'); INSERT INTO `t_registration` VALUES (260027, 10022, 10020, '2005-09-12'); INSERT INTO `t_registration` VALUES (270028, 10040, 10015, '2012-02-08'); INSERT INTO `t_registration` VALUES (280029, 10008, 10010, '2023-08-05'); INSERT INTO `t_registration` VALUES (290030, 10045, 10013, '2009-01-15'); INSERT INTO `t_registration` VALUES (300031, 10028, 10010, '2005-10-26'); INSERT INTO `t_registration` VALUES (310032, 10024, 10016, '2007-02-05'); INSERT INTO `t_registration` VALUES (320033, 10006, 10012, '2005-01-09'); INSERT INTO `t_registration` VALUES (330034, 10036, 10009, '2012-07-04'); INSERT INTO `t_registration` VALUES (340035, 10015, 10010, '2016-01-14'); INSERT INTO `t_registration` VALUES (350036, 10025, 10007, '2007-07-16'); INSERT INTO `t_registration` VALUES (360037, 10046, 10009, '2003-11-21'); INSERT INTO `t_registration` VALUES (370038, 10042, 10019, '2015-08-22'); INSERT INTO `t_registration` VALUES (380039, 10047, 10008, '2003-12-11'); INSERT INTO `t_registration` VALUES (390040, 10030, 10011, '2023-11-03'); INSERT INTO `t_registration` VALUES (400041, 10041, 10011, '2009-10-31'); INSERT INTO `t_registration` VALUES (410042, 10001, 10015, '2016-01-28'); INSERT INTO `t_registration` VALUES (420043, 10029, 10020, '2001-01-31'); INSERT INTO `t_registration` VALUES (430044, 10050, 10018, '2015-06-07'); INSERT INTO `t_registration` VALUES (440045, 10031, 10018, '2011-11-30'); INSERT INTO `t_registration` VALUES (450046, 10003, 10004, '2022-06-13'); INSERT INTO `t_registration` VALUES (460047, 10004, 10002, '2017-07-12'); INSERT INTO `t_registration` VALUES (470048, 10027, 10003, '2005-07-13'); INSERT INTO `t_registration` VALUES (480049, 10023, 10019, '2015-05-13'); INSERT INTO `t_registration` VALUES (490050, 10019, 10007, '2011-09-14'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题四/db_grade.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_grade Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 23/11/2023 15:31:23 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(11) NOT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `total` int(5) NULL DEFAULT NULL, PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '英语', 150); INSERT INTO `t_course` VALUES (10002, '语文', 150); INSERT INTO `t_course` VALUES (10003, '数学', 150); -- ---------------------------- -- Table structure for t_grade -- ---------------------------- DROP TABLE IF EXISTS `t_grade`; CREATE TABLE `t_grade` ( `gid` int(10) NOT NULL, `sid` int(10) NOT NULL, `cid` int(10) NOT NULL, `score` int(10) NULL DEFAULT NULL, PRIMARY KEY (`gid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_grade -- ---------------------------- INSERT INTO `t_grade` VALUES (10001, 10010, 10003, 53); INSERT INTO `t_grade` VALUES (10002, 10001, 10002, 52); INSERT INTO `t_grade` VALUES (10003, 10007, 10003, 53); INSERT INTO `t_grade` VALUES (10004, 10001, 10001, 124); INSERT INTO `t_grade` VALUES (10005, 10003, 10003, 119); INSERT INTO `t_grade` VALUES (10006, 10003, 10002, 145); INSERT INTO `t_grade` VALUES (10007, 10008, 10002, 109); INSERT INTO `t_grade` VALUES (10008, 10006, 10002, 101); INSERT INTO `t_grade` VALUES (10009, 10003, 10001, 128); INSERT INTO `t_grade` VALUES (10010, 10002, 10001, 110); INSERT INTO `t_grade` VALUES (10011, 10002, 10003, 146); INSERT INTO `t_grade` VALUES (10012, 10007, 10001, 132); INSERT INTO `t_grade` VALUES (10013, 10010, 10001, 126); INSERT INTO `t_grade` VALUES (10014, 10010, 10002, 104); INSERT INTO `t_grade` VALUES (10015, 10006, 10001, 109); INSERT INTO `t_grade` VALUES (10016, 10001, 10003, 99); INSERT INTO `t_grade` VALUES (10017, 10002, 10002, 138); INSERT INTO `t_grade` VALUES (10018, 10006, 10003, 105); INSERT INTO `t_grade` VALUES (10019, 10008, 10001, 141); INSERT INTO `t_grade` VALUES (10020, 10005, 10002, 90); INSERT INTO `t_grade` VALUES (10021, 10004, 10003, 54); INSERT INTO `t_grade` VALUES (10022, 10005, 10003, 86); INSERT INTO `t_grade` VALUES (10023, 10009, 10001, 138); INSERT INTO `t_grade` VALUES (10024, 10005, 10001, 126); INSERT INTO `t_grade` VALUES (10025, 10007, 10002, 111); INSERT INTO `t_grade` VALUES (10026, 10009, 10003, 120); INSERT INTO `t_grade` VALUES (10027, 10004, 10002, 103); INSERT INTO `t_grade` VALUES (10028, 10009, 10002, 125); INSERT INTO `t_grade` VALUES (10029, 10004, 10001, 87); INSERT INTO `t_grade` VALUES (10030, 10008, 10003, 51); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(11) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '夏震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10002, '孔璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10003, '田璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10004, '田秀英', '女', '高二3班'); INSERT INTO `t_student` VALUES (10005, '宋詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10006, '薛詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10007, '石震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10008, '梁致远', '男', '高二3班'); INSERT INTO `t_student` VALUES (10009, '顾璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10010, '魏晓明', '男', '高二3班'); SET FOREIGN_KEY_CHECKS = 1; $ 《MySQL数据库基础》 期末复习卷(一) 时间:90分钟 总分:100分 班级 姓名 学号 成绩 一．数据库操作题(本大题共5小题,每小题20分,共100分) 1.房屋租赁系统数据库db_lease包含了t_house房屋信息表、t_client客户表和t_order订单表 t_house包含字段hid(房屋编号),address(地址),tel(户主联系电话),type(房屋类型),decoration(装修情况),area(面积),price(每月价格) t_client包含字段 cid(客户编号),name(客户姓名),tel(联系电话),need (需求备注) t_order包含字段oid(订单编号),cid(客户编号),hid(房屋编号),time(租赁时间),duration(租赁时长) 1).创建预约看房表t_appointment,字段如下: aid(预约编号) char(10) 主键 cid(客户编号) char(10) 非空 hid(房屋编号) char(10) 非空 apptime(预约时间) datetime status(状态) varchar(20) 默认待看房 2).向t_appointment表中插入一条数据:预约编号a0001,客户编号c0005,房屋编号h0003,预约时间2025-04-10 14:30:00 3).为t_house表添加status字段(出租状态),类型varchar(20),默认未出租 4).将t_house表中房屋编号h0008的每月价格修改为 2800 5).用SQL语句查询面积大于80平方米且装修情况为精装的所有房屋信息 6).用SQL语句查询客户张三的所有订单,显示客户姓名、房屋地址、租赁时长 7).创建视图v_rent_order,显示订单信息,字段:客户姓名、联系电话、房屋地址、每月价格、租赁时长 2.社交网络数据库db_social包含了t_user用户表、t_friendship好友关系表、t_post动态表、点赞表 t_user包含字段uid(用户编号),username(用户名),password(密码),nickname(昵称),age(年龄),sex(性别)。 t_friendship包含字段fsid(好友关系编号),uid(用户id),fid(好友id),createtime(添加时间)。 t_post包含字段pid(动态编号),uid(用户编号),content(内容),createtime(创建时间) t_likes包含字段lid(点赞编号),pid(动态编号),fid(好友id),createtime(点赞时间) 1).创建评论表t_comment,字段如下: cmid(评论编号) char(10) 主键 pid(动态编号) char(10) 非空 uid(用户编号) char(10) 非空 content(评论内容) text createtime(创建时间) datetime 2).向t_comment表中插入一条数据:评论编号c0001,动态编号 p0002,用户编号u0005,评论内容写得真好,创建时间2025-04-01 10:00:00 3).为t_user表添加regtime字段(注册时间),类型datetime 4).将t_user表中用户编号u0010的昵称修改为阳光男孩 5).用SQL语句查询年龄在18-25岁之间的所有女性用户信息 6).用SQL语句查询用户李明的所有好友昵称和添加时间 7).创建视图v_user_likes,显示用户点赞记录,字段:昵称、动态内容、点赞时 8).创建触发器:当向t_likes表中插入一条点赞记录时,自动更新对应动态的点赞数量字段 9).创建存储过程proc_add_friend,输入参数为两个用户编号(uid1, uid2),实现双向添加好友 3.线上教育数据库db_education包含了t_student学生表、t_course课程表、t_Learn学习记录表和t_video视频表 t_student包含字段sid(学生编号),sname(学生姓名),username(用户名),password(密码),classes(班级)。 t_course包含字段 cid(课程编号),cname(课程名称),description(描述), classhour(课时)。 t_video包括字段vid(视频编号),cid(课程编号),title(标题),link(链接地址) t_Learn学习记录表lid(学习记录编号),sid(学生编号),cid(课程编号),schedule(学习进度),createtime(创建时间)。 1).创建作业表t_homework,字段如下: hid(作业编号) char(10) 主键 cid(课程编号) char(10) 非空 title(作业标题) varchar(100) deadline(截止时间)datetime 2).向t_homework表中插入一条数据:作业编号 h0001,课程编号 c0003,作业标题第一章课后练习,截止时间 2025-04-20 23:59:59 3).为t_student表添加email字段(邮箱),类型 varchar(50) 4).将t_student表中用户名为xiaoming的密码修改为newpass123" 5).用SQL语句查询班级为高二2班的所有学生信息 6).用SQL语句查询数学课程的所有视频信息,显示课程名称、视频标题、链接地址 7).创建视图v_learn_record显示学生学习记录,字段:学生姓名、课程名称、学习进度、创建时间 8).创建触发器:当向t_Learn学习记录表中插入或更新学习进度时,如果进度达到 100%,则自动在t_course表中记录该学生完成该课程(假设t_course中增加字段completed_count统计完成人数) 9).创建存储过程proc_get_course_progress,输入参数为学生编号sid,返回该学生所有课程的学习进度(显示课程名称、进度百分比) 4.学生成绩系统数据库db_grade包含了t_student学生表t_grade成绩表和t_course科目表 t_student包含字段sid(学生编号),sname(姓名),sex(性别),class(班级)。 t_course包含字段 cid(科目编号),cname(科目名称),total(总分)。 t_grade包含字段gid(成绩编号),sid(学生编号),cid(科目编号),score (分数)。 1).创建成绩分析表 t_analysis,字段如下: aid(分析编号) char(10) 主键 sid(学生编号) char(10) 非空 avgscore(平均分) decimal(5,2) rank(排名) int updatetime(更新时间) datetime 2).向t_analysis表中插入一条数据:分析编号a0001,学生编号s0002,平均分 85.5,排名 3,更新时间2025-04-01 3).为t_course表添加credit字段(学分),类型 int,默认 2 4).将t_course表中科目编号c0005的总分修改为 120 5).用SQL语句查询班级为高三1班的所有学生信息 6).用SQL语句查询数学科目成绩大于 90 分的学生,显示学生姓名、班级、数学成绩 7).创建视图v_student_grade,显示学生成绩,字段:学生姓名、班级、科目名称、分数、总分 8).创建触发器:当向t_grade成绩表中插入或更新分数时,自动计算该学生的平均分并更新到t_analysis表中 9).创建存储过程proc_class_rank,输入参数为班级名称和科目编号,返回该班级在该科目中的学生成绩排名(按分数从高到低) 5.医疗管理数据库db_treatment包含了t_patient患者表、t_doctor医生表、t_registration挂号表 t_patient包含字段pid(患者编号),pname(患者姓名),sex(性别),age(年龄),tel(联系电话)。 t_doctor包含字段 did(医生编号),dname(医生姓名),office(科室), title(职称),tel(联系电话)。 t_registration包括字段rid(挂号编号),pid(患者编号),did(医生编号),rtime(挂号日期)。 1).创建病历表 t_medical,字段如下: mid(病历编号) char(10) 主键 pid(患者编号) char(10) 非空 did(医生编号) char(10) 非空 diagnosis(诊断结果) text medtime(就诊时间) datetime 2).向t_medical表中插入一条数据:病历编号m0001,患者编号p0004,医生编号d0002,诊断结果上呼吸道感染,就诊时间2025-04-03 09:30:00 3).为t_doctor表添加years字段(工作年限),类型 int,默认 0 4).将t_doctor表中医生编号d0010的联系电话修改为13812345678" 5).用SQL语句查询所有内科医生的姓名、职称和联系电话 6).用SQL语句查询患者王芳的所有挂号记录,显示患者姓名、医生姓名、科室、挂号日期 7).创建视图v_registration_info,显示挂号信息,字段:患者姓名、联系电话、医生姓名、科室、挂号日期 8).创建触发器:当向t_registration挂号表中插入一条记录时,自动检查该医生当天挂号人数是否超过30人,如果超过则拒绝插入 9).创建存储过程proc_doctor_patient_count,输入参数为医生编号和挂号日期,返回该医生在指定日期的挂号患者数量 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题一/db_lease.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_lease Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 23/11/2023 10:28:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_client -- ---------------------------- DROP TABLE IF EXISTS `t_client`; CREATE TABLE `t_client` ( `cid` int(11) NULL DEFAULT NULL, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `need` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_client -- ---------------------------- INSERT INTO `t_client` VALUES (10001, '蔡致远', '19503210699', '精装'); INSERT INTO `t_client` VALUES (10002, '谢子异', '7696954760', '两室'); INSERT INTO `t_client` VALUES (10003, '田宇宁', '108144296', '毛胚'); INSERT INTO `t_client` VALUES (10004, '沈杰宏', '104971363', '两室'); INSERT INTO `t_client` VALUES (10005, '汤睿', '2068695528', '毛胚'); INSERT INTO `t_client` VALUES (10006, '薛岚', '14879352296', '毛胚'); INSERT INTO `t_client` VALUES (10007, '秦岚', '13545030053', '单间'); INSERT INTO `t_client` VALUES (10008, '郑杰宏', '2183213547', '毛胚'); INSERT INTO `t_client` VALUES (10009, '谢秀英', '14067372900', '单间'); INSERT INTO `t_client` VALUES (10010, '范致远', '18789991507', '单间'); INSERT INTO `t_client` VALUES (10011, '杨云熙', '19481632713', '两室'); INSERT INTO `t_client` VALUES (10012, '石子异', '2165515768', '单间'); INSERT INTO `t_client` VALUES (10013, '韦秀英', '2872609276', '两室'); INSERT INTO `t_client` VALUES (10014, '张致远', '76035737758', '精装'); INSERT INTO `t_client` VALUES (10015, '孙詩涵', '17793665808', '单间'); INSERT INTO `t_client` VALUES (10016, '陶嘉伦', '18568570306', '精装'); INSERT INTO `t_client` VALUES (10017, '徐晓明', '15655432389', '简装'); INSERT INTO `t_client` VALUES (10018, '何云熙', '19437875223', '简装'); INSERT INTO `t_client` VALUES (10019, '孙杰宏', '289342263', '精装'); INSERT INTO `t_client` VALUES (10020, '范震南', '13121528802', '毛胚'); -- ---------------------------- -- Table structure for t_house -- ---------------------------- DROP TABLE IF EXISTS `t_house`; CREATE TABLE `t_house` ( `hid` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` int(20) NULL DEFAULT NULL, `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `decoration` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `area` int(5) NULL DEFAULT NULL, `price` int(5) NULL DEFAULT NULL, PRIMARY KEY (`hid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_house -- ---------------------------- INSERT INTO `t_house` VALUES (10001, '中国北京市西城区西長安街354号43室', 10146743, '三室一厅', '精装', 73, 1705); INSERT INTO `t_house` VALUES (10002, '中国东莞环区南街二巷284号28室', 18084482, '三室两厅', '精装', 102, 889); INSERT INTO `t_house` VALUES (10003, '中国北京市海淀区清河中街68号478号31栋', 15712749, '三室两厅', '精装', 96, 1000); INSERT INTO `t_house` VALUES (10004, '中国深圳龙岗区学园一巷533号41栋', 19563209, '三室一厅', '毛胚', 125, 1921); INSERT INTO `t_house` VALUES (10005, '中国中山乐丰六路892号华润大厦41室', 19823516, '三室两厅', '毛胚', 74, 1271); INSERT INTO `t_house` VALUES (10006, '中国上海市浦东新区健祥路633号22楼', 16335231, '两室一厅', '精装', 112, 1179); INSERT INTO `t_house` VALUES (10007, '中国东莞环区南街二巷658号45楼', 19297583, '三室一厅', '简装', 92, 1843); INSERT INTO `t_house` VALUES (10008, '中国中山京华商圈华夏街595号华润大厦31室', 12692049, '三室两厅', '毛胚', 93, 1212); INSERT INTO `t_house` VALUES (10009, '中国北京市房山区岳琉路334号38号楼', 18408913, '一室一厅', '精装', 115, 1298); INSERT INTO `t_house` VALUES (10010, '中国深圳罗湖区清水河一路25号34室', 14485481, '三室两厅', '精装', 112, 985); INSERT INTO `t_house` VALUES (10011, '中国东莞东泰五街26号29号楼', 13695465, '三室一厅', '精装', 85, 1084); INSERT INTO `t_house` VALUES (10012, '中国广州市白云区机场路棠苑街五巷771号华润大厦43室', 17241769, '两室一厅', '毛胚', 84, 1072); INSERT INTO `t_house` VALUES (10013, '中国中山紫马岭商圈中山五路68号8楼', 19474063, '三室一厅', '毛胚', 114, 1434); INSERT INTO `t_house` VALUES (10014, '中国北京市東城区東直門內大街509号26栋', 18408702, '三室两厅', '精装', 83, 1152); INSERT INTO `t_house` VALUES (10015, '中国广州市海珠区江南西路13号10室', 13507746, '三室一厅', '精装', 79, 1408); INSERT INTO `t_house` VALUES (10016, '中国广州市天河区天河路660号18栋', 17834698, '两室一厅', '精装', 110, 1676); INSERT INTO `t_house` VALUES (10017, '中国广州市越秀区中山二路829号11号楼', 15707608, '一室一厅', '毛胚', 113, 1301); INSERT INTO `t_house` VALUES (10018, '中国成都市成华区双庆路404号华润大厦22室', 16839914, '两室一厅', '精装', 90, 1423); INSERT INTO `t_house` VALUES (10019, '中国深圳龙岗区学园一巷217号8楼', 14488797, '一室一厅', '精装', 116, 1331); INSERT INTO `t_house` VALUES (10020, '中国成都市锦江区红星路三段947号25号楼', 10422150, '三室一厅', '精装', 74, 1594); -- ---------------------------- -- Table structure for t_order -- ---------------------------- DROP TABLE IF EXISTS `t_order`; CREATE TABLE `t_order` ( `oid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL, `hid` int(11) NOT NULL, `time` date NULL DEFAULT NULL, `duration` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`oid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order -- ---------------------------- INSERT INTO `t_order` VALUES (10001, 10010, 10008, '2020-12-19', '三个月'); INSERT INTO `t_order` VALUES (10002, 10001, 10020, '2022-01-03', '半年'); INSERT INTO `t_order` VALUES (10003, 10017, 10019, '2020-05-14', '半年'); INSERT INTO `t_order` VALUES (10004, 10005, 10004, '2000-11-07', '半年'); INSERT INTO `t_order` VALUES (10005, 10008, 10006, '2001-10-18', '一年'); INSERT INTO `t_order` VALUES (10006, 10020, 10010, '2010-07-29', '一年'); INSERT INTO `t_order` VALUES (10007, 10018, 10017, '2003-12-12', '一年'); INSERT INTO `t_order` VALUES (10008, 10004, 10013, '2001-01-28', '三个月'); INSERT INTO `t_order` VALUES (10009, 10016, 10018, '2023-03-04', '三个月'); INSERT INTO `t_order` VALUES (10010, 10013, 10005, '2012-06-30', '三个月'); INSERT INTO `t_order` VALUES (10011, 10014, 10003, '2010-07-23', '长期'); INSERT INTO `t_order` VALUES (10012, 10007, 10015, '2009-06-03', '三个月'); INSERT INTO `t_order` VALUES (10013, 10009, 10011, '2003-09-29', '长期'); INSERT INTO `t_order` VALUES (10014, 10006, 10009, '2010-05-01', '一年'); INSERT INTO `t_order` VALUES (10015, 10011, 10002, '2021-07-18', '长期'); INSERT INTO `t_order` VALUES (10016, 10015, 10012, '2019-06-19', '半年'); INSERT INTO `t_order` VALUES (10017, 10019, 10016, '2015-05-26', '半年'); INSERT INTO `t_order` VALUES (10018, 10012, 10001, '2018-11-14', '三个月'); INSERT INTO `t_order` VALUES (10019, 10002, 10014, '2016-09-03', '三个月'); INSERT INTO `t_order` VALUES (10020, 10003, 10007, '2013-07-09', '一年'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《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: 05/12/2023 09:42:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(10) NULL DEFAULT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classhour` int(10) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '语文', '高中语文课程', 24); INSERT INTO `t_course` VALUES (10002, '数学', '高中数学课程', 24); INSERT INTO `t_course` VALUES (10003, '英语', '高中英语课程', 24); -- ---------------------------- -- Table structure for t_learn -- ---------------------------- DROP TABLE IF EXISTS `t_learn`; CREATE TABLE `t_learn` ( `lid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `schedule` int(10) NULL DEFAULT 0, `createtime` date NULL DEFAULT NULL, PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_learn -- ---------------------------- INSERT INTO `t_learn` VALUES ('10001', '10026', '10003', 8, '2001-08-21'); INSERT INTO `t_learn` VALUES ('10002', '10044', '10001', 7, '2001-01-30'); INSERT INTO `t_learn` VALUES ('10003', '10024', '10003', 15, '2011-11-02'); INSERT INTO `t_learn` VALUES ('10004', '10029', '10003', 15, '2019-08-20'); INSERT INTO `t_learn` VALUES ('10005', '10042', '10003', 19, '2005-09-13'); INSERT INTO `t_learn` VALUES ('10006', '10033', '10004', 7, '2006-09-05'); INSERT INTO `t_learn` VALUES ('10007', '10043', '10004', 16, '2015-01-16'); INSERT INTO `t_learn` VALUES ('10008', '10037', '10002', 18, '2008-06-16'); INSERT INTO `t_learn` VALUES ('10009', '10010', '10003', 4, '2011-02-08'); INSERT INTO `t_learn` VALUES ('10010', '10034', '10004', 22, '2001-03-18'); INSERT INTO `t_learn` VALUES ('10011', '10021', '10003', 3, '2005-04-02'); INSERT INTO `t_learn` VALUES ('10012', '10036', '10001', 18, '2019-02-23'); INSERT INTO `t_learn` VALUES ('10013', '10002', '10003', 10, '2002-06-14'); INSERT INTO `t_learn` VALUES ('10014', '10030', '10003', 7, '2023-11-04'); INSERT INTO `t_learn` VALUES ('10015', '10011', '10002', 1, '2002-12-28'); INSERT INTO `t_learn` VALUES ('10016', '10035', '10004', 13, '2003-05-17'); INSERT INTO `t_learn` VALUES ('10017', '10014', '10003', 9, '2017-09-01'); INSERT INTO `t_learn` VALUES ('10018', '10015', '10001', 11, '2001-05-26'); INSERT INTO `t_learn` VALUES ('10019', '10012', '10003', 8, '2009-04-21'); INSERT INTO `t_learn` VALUES ('10020', '10017', '10003', 4, '2018-08-24'); INSERT INTO `t_learn` VALUES ('10021', '10003', '10003', 5, '2019-07-31'); INSERT INTO `t_learn` VALUES ('10022', '10038', '10003', 23, '2011-12-29'); INSERT INTO `t_learn` VALUES ('10023', '10032', '10003', 14, '2003-08-19'); INSERT INTO `t_learn` VALUES ('10024', '10039', '10003', 12, '2004-02-06'); INSERT INTO `t_learn` VALUES ('10025', '10041', '10001', 21, '2002-07-12'); INSERT INTO `t_learn` VALUES ('10026', '10006', '10001', 13, '2013-10-15'); INSERT INTO `t_learn` VALUES ('10027', '10020', '10001', 16, '2020-06-08'); INSERT INTO `t_learn` VALUES ('10028', '10008', '10001', 13, '2023-11-18'); INSERT INTO `t_learn` VALUES ('10029', '10007', '10003', 10, '2000-12-21'); INSERT INTO `t_learn` VALUES ('10030', '10049', '10004', 3, '2021-12-24'); INSERT INTO `t_learn` VALUES ('10031', '10047', '10004', 7, '2005-04-17'); INSERT INTO `t_learn` VALUES ('10032', '10023', '10002', 16, '2002-09-10'); INSERT INTO `t_learn` VALUES ('10033', '10019', '10002', 7, '2021-03-27'); INSERT INTO `t_learn` VALUES ('10034', '10001', '10003', 5, '2010-10-03'); INSERT INTO `t_learn` VALUES ('10035', '10028', '10004', 11, '2008-05-06'); INSERT INTO `t_learn` VALUES ('10036', '10016', '10002', 24, '2009-05-27'); INSERT INTO `t_learn` VALUES ('10037', '10009', '10002', 2, '2021-05-03'); INSERT INTO `t_learn` VALUES ('10038', '10027', '10004', 11, '2022-10-06'); INSERT INTO `t_learn` VALUES ('10039', '10040', '10003', 8, '2023-03-01'); INSERT INTO `t_learn` VALUES ('10040', '10031', '10003', 5, '2017-04-23'); INSERT INTO `t_learn` VALUES ('10041', '10050', '10004', 0, '2017-04-16'); INSERT INTO `t_learn` VALUES ('10042', '10025', '10002', 14, '2020-11-18'); INSERT INTO `t_learn` VALUES ('10043', '10048', '10003', 3, '2000-02-01'); INSERT INTO `t_learn` VALUES ('10044', '10005', '10001', 2, '2000-07-30'); INSERT INTO `t_learn` VALUES ('10045', '10046', '10001', 6, '2009-01-21'); INSERT INTO `t_learn` VALUES ('10046', '10004', '10001', 14, '2011-05-07'); INSERT INTO `t_learn` VALUES ('10047', '10022', '10003', 14, '2007-09-05'); INSERT INTO `t_learn` VALUES ('10048', '10013', '10003', 20, '2002-04-02'); INSERT INTO `t_learn` VALUES ('10049', '10018', '10004', 10, '2010-05-19'); INSERT INTO `t_learn` VALUES ('10050', '10045', '10003', 10, '2015-10-31'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(10) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `classes` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '贾子韬', 'rqkpnrpw', 'qGhyfhyGio', '高一1班'); INSERT INTO `t_student` VALUES (10002, '曾詩涵', 'wllbpxpf', 'Ft8qo5iwJ0', '高三2班'); INSERT INTO `t_student` VALUES (10003, '高睿', 'gzairzdb', 'C1L1N4OBX4', '高二2班'); INSERT INTO `t_student` VALUES (10004, '孔璐', 'plgtkjxy', '4ARIJvsdI7', '高三1班'); INSERT INTO `t_student` VALUES (10005, '邱璐', 'dkhtjxob', 'aa9NUeo9sF', '高一1班'); INSERT INTO `t_student` VALUES (10006, '林晓明', 'lbtkgcep', 'q7GaI78tY3', '高三1班'); INSERT INTO `t_student` VALUES (10007, '廖子异', 'heumgwpi', '9iCA9pCACl', '高二2班'); INSERT INTO `t_student` VALUES (10008, '吴宇宁', 'immknini', 'hnlwlWXfMw', '高二2班'); INSERT INTO `t_student` VALUES (10009, '陶致远', 'vaaibzte', 'zSyRZSbTll', '高三2班'); INSERT INTO `t_student` VALUES (10010, '田致远', 'hvmqiebm', 'Fvm4G9VhkZ', '高二2班'); INSERT INTO `t_student` VALUES (10011, '任震南', 'bkqoxgrp', 'ZM5Cw5utTm', '高一2班'); INSERT INTO `t_student` VALUES (10012, '雷岚', 'mhrviqys', '9aVltYbPHE', '高一2班'); INSERT INTO `t_student` VALUES (10013, '傅子韬', 'yxvpgzui', '0sPq0v3IeJ', '高一2班'); INSERT INTO `t_student` VALUES (10014, '韦杰宏', 'bqifzjrt', '9Oo6J5odqP', '高二1班'); INSERT INTO `t_student` VALUES (10015, '马子异', 'zzhjqmrz', 'a1gMAwnLs2', '高三2班'); INSERT INTO `t_student` VALUES (10016, '莫秀英', 'bxktahbz', 'IWCVNvMGL6', '高一2班'); INSERT INTO `t_student` VALUES (10017, '常宇宁', 'xdbqtnqs', 'w8Dn5mTtGp', '高一2班'); INSERT INTO `t_student` VALUES (10018, '朱子异', 'qjstcwjc', 'Zr2mtrMpVE', '高三1班'); INSERT INTO `t_student` VALUES (10019, '方震南', 'syfrtkyu', '2AoUfr5ZnK', '高一1班'); INSERT INTO `t_student` VALUES (10020, '沈宇宁', 'ictjevir', '5F24FmvV1q', '高二2班'); INSERT INTO `t_student` VALUES (10021, '吕安琪', 'caquymom', 'EAQjHmn8z7', '高一2班'); INSERT INTO `t_student` VALUES (10022, '宋璐', 'dpbgvoqx', 'TT3IPCOX5B', '高一1班'); INSERT INTO `t_student` VALUES (10023, '潘秀英', 'bqxhwqdf', 'DNGok5w6CC', '高三1班'); INSERT INTO `t_student` VALUES (10024, '莫詩涵', 'ktmtgcrs', 'OKkp6v553e', '高三1班'); INSERT INTO `t_student` VALUES (10025, '熊璐', 'txfpxsis', 'T54gy0Hb3S', '高三2班'); INSERT INTO `t_student` VALUES (10026, '潘震南', 'ihrjenzb', 'w2R8wdbUug', '高三2班'); INSERT INTO `t_student` VALUES (10027, '陈詩涵', 'qehknger', 'fPp0m6qm4A', '高一2班'); INSERT INTO `t_student` VALUES (10028, '严杰宏', 'swhwmmbn', 'UJpPxYXcfG', '高一1班'); INSERT INTO `t_student` VALUES (10029, '韩璐', 'rgwoyxfj', 'fpRrn8hP7k', '高一1班'); INSERT INTO `t_student` VALUES (10030, '汪詩涵', 'qeiwzawn', 'mdDK734hYf', '高二1班'); INSERT INTO `t_student` VALUES (10031, '尹子异', 'iojbrdtg', '0o3Ymue1Ts', '高一1班'); INSERT INTO `t_student` VALUES (10032, '贾秀英', 'pjrbxcgi', 'wvQ7ul5Ygl', '高二2班'); INSERT INTO `t_student` VALUES (10033, '吕震南', 'oedjepmq', 'EpkZMcblN4', '高三2班'); INSERT INTO `t_student` VALUES (10034, '金杰宏', 'zedxgqur', 'upz5cfstS8', '高二2班'); INSERT INTO `t_student` VALUES (10035, '汪震南', 'azlhdsgv', 'UEjf4k3J4Y', '高一1班'); INSERT INTO `t_student` VALUES (10036, '邹秀英', 'ezcuzosf', 'AVDfHqPSBA', '高一1班'); INSERT INTO `t_student` VALUES (10037, '韦子韬', 'thghwrxm', 'hOPYmq90aI', '高三2班'); INSERT INTO `t_student` VALUES (10038, '邓岚', 'xibjqcqr', 'KHVLMHEdB2', '高二1班'); INSERT INTO `t_student` VALUES (10039, '侯晓明', 'wqsboqtx', '1JlWkJhuin', '高二1班'); INSERT INTO `t_student` VALUES (10040, '方睿', 'rigthudo', 'iOolu1XLWk', '高三2班'); INSERT INTO `t_student` VALUES (10041, '丁宇宁', 'xajjnxdn', '2OPHE1Xwdt', '高二1班'); INSERT INTO `t_student` VALUES (10042, '胡嘉伦', 'njybwilz', 'T4FyjyQ06G', '高二2班'); INSERT INTO `t_student` VALUES (10043, '孟岚', 'nvkvehrp', 'JkSNXREhIK', '高三2班'); INSERT INTO `t_student` VALUES (10044, '孟云熙', 'kkkpqfgs', 'PmdSsBaIVE', '高三2班'); INSERT INTO `t_student` VALUES (10045, '曹宇宁', 'falyiyal', 'LZruWY2x3D', '高二1班'); INSERT INTO `t_student` VALUES (10046, '陶睿', 'qyatgwvv', 'reKaYJZup4', '高三2班'); INSERT INTO `t_student` VALUES (10047, '程嘉伦', 'ytehfenv', 'xK2tx3HDDg', '高二1班'); INSERT INTO `t_student` VALUES (10048, '贺子韬', 'fwloybvz', '8qdM7vBgi6', '高三2班'); INSERT INTO `t_student` VALUES (10049, '石安琪', 'dcjajfyv', 'TT2kI3uUNK', '高三2班'); INSERT INTO `t_student` VALUES (10050, '贺岚', 'vqxzrdft', 'XE4wrXCITj', '高三2班'); -- ---------------------------- -- Table structure for t_video -- ---------------------------- DROP TABLE IF EXISTS `t_video`; CREATE TABLE `t_video` ( `vid` int(10) NOT NULL AUTO_INCREMENT, `cid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`vid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10073 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_video -- ---------------------------- INSERT INTO `t_video` VALUES (10001, '10002', 'To successfully establish a new ', 'https://video.misgo.us/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10002, '10003', 'It is used while your ISPs do not ', 'http://video.fancm.us/ToysGames'); INSERT INTO `t_video` VALUES (10003, '10003', 'In other words, Navicat provides ', 'http://video.harada75.cn/Beauty'); INSERT INTO `t_video` VALUES (10004, '10002', 'It collects process metrics such ', 'http://video.kuliksun.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10005, '10003', 'Creativity is intelligence having fun.', 'https://video.waisanyam87.com/VideoGames'); INSERT INTO `t_video` VALUES (10006, '10002', 'Such sessions are also susceptible ', 'http://video.chin44.cn/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10007, '10001', 'What you get by achieving your ', 'http://video.tanganqi.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10008, '10002', 'I will greet this day with love in my heart.', 'https://video.yinyunx.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10009, '10002', 'HTTP Tunneling is a method for ', 'http://video.fatl803.com/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10010, '10001', 'The first step is as good as half over. ', 'https://video.wuzhenn.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10011, '10003', 'To connect to a database or schema, ', 'http://video.lu15.xyz/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10012, '10001', 'The past has no power over the present moment.', 'http://video.burnsheather.info/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10013, '10001', 'It is used while your ISPs do not ', 'http://video.nts.com/HouseholdKitchenAppliances'); INSERT INTO `t_video` VALUES (10014, '10001', 'The reason why a great man is great ', 'http://video.cheng1.xyz/Appliances'); INSERT INTO `t_video` VALUES (10015, '10003', 'The Main Window consists of several ', 'https://video.monicacraw5.info/HealthBabyCare'); INSERT INTO `t_video` VALUES (10016, '10001', 'The first step is as good as half over.', 'https://video.kinoshitahikaru1988.jp/Appliances'); INSERT INTO `t_video` VALUES (10017, '10002', 'In the Objects tab, you can use ', 'http://video.anoguchi.com/Others'); INSERT INTO `t_video` VALUES (10018, '10001', 'To start working with your server ', 'https://video.hicksjulie.xyz/SportsOutdoor'); INSERT INTO `t_video` VALUES (10019, '10003', 'The past has no power over the present moment.', 'https://video.sklo.org/FilmSupplies'); INSERT INTO `t_video` VALUES (10020, '10003', 'The On Startup feature allows you ', 'http://video.jijiang47.net/HealthBabyCare'); INSERT INTO `t_video` VALUES (10021, '10001', 'Navicat provides a wide range advanced ', 'http://video.linzita.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10022, '10002', 'The Information Pane shows the ', 'https://video.barnfr4.jp/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10023, '10002', 'If it scares you, it might be a good thing to try.', 'https://video.shi704.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10024, '10001', 'Navicat Data Modeler is a powerful ', 'https://video.xu2015.xyz/VideoGames'); INSERT INTO `t_video` VALUES (10025, '10002', 'There is no way to happiness. Happiness ', 'http://video.suy.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10026, '10002', 'I will greet this day with love in my heart.', 'http://video.tang420.org/Baby'); INSERT INTO `t_video` VALUES (10027, '10003', 'In the middle of winter I at last ', 'https://video.xiy6.xyz/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10028, '10003', 'The Main Window consists of several ', 'https://video.jr59.jp/ComputersElectronics'); INSERT INTO `t_video` VALUES (10029, '10001', 'A query is used to extract data ', 'http://video.sakuroka1109.net/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10030, '10003', 'All journeys have secret destinations ', 'http://video.mmiyamoto.xyz/Appliances'); INSERT INTO `t_video` VALUES (10031, '10003', 'Navicat Monitor can be installed ', 'https://video.gard.com/CDsVinyl'); INSERT INTO `t_video` VALUES (10032, '10002', 'What you get by achieving your ', 'http://video.jefferywhi9.jp/AppsGames'); INSERT INTO `t_video` VALUES (10033, '10001', 'Navicat provides a wide range advanced ', 'http://video.ziyx2010.net/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10034, '10001', 'Optimism is the one quality more ', 'http://video.lxiu1.co.jp/Handcrafts'); INSERT INTO `t_video` VALUES (10035, '10003', 'The On Startup feature allows you ', 'https://video.carmenhug.info/Baby'); INSERT INTO `t_video` VALUES (10036, '10002', 'The past has no power over the present moment.', 'http://video.cyuning.co.jp/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10037, '10002', 'A man is not old until regrets ', 'http://video.yunxi84.co.jp/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10038, '10003', 'Secure Sockets Layer(SSL) is a ', 'http://video.jiechan.cn/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10039, '10002', 'The Main Window consists of several ', 'https://video.randyspe.us/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10040, '10003', 'Navicat Monitor requires a repository ', 'https://video.kwokkn10.info/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10041, '10001', 'If the Show objects under schema ', 'https://video.okfan.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10042, '10003', 'To successfully establish a new ', 'https://video.liziyi.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10043, '10003', 'SQL Editor allows you to create ', 'http://video.kcharles.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10044, '10002', 'A man is not old until regrets ', 'http://video.sseiko.com/VideoGames'); INSERT INTO `t_video` VALUES (10045, '10001', 'If opportunity doesn’t knock, build a door.', 'http://video.ngkm.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10046, '10002', 'To successfully establish a new ', 'https://video.lsze.biz/MusicalInstrument'); INSERT INTO `t_video` VALUES (10047, '10002', 'I may not have gone where I intended ', 'http://video.whwu9.xyz/AppsGames'); INSERT INTO `t_video` VALUES (10048, '10001', 'You will succeed because most people are lazy.', 'https://video.bh4.us/PetSupplies'); INSERT INTO `t_video` VALUES (10049, '10003', 'Actually it is just in an idea ', 'https://video.duanxia104.net/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10050, '10003', 'The reason why a great man is great ', 'https://video.zhennanwe.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10051, '10002', 'Navicat Monitor can be installed ', 'http://video.xiaoziyi.cn/Beauty'); INSERT INTO `t_video` VALUES (10052, '10003', 'I destroy my enemies when I make them my friends.', 'https://video.melissa506.us/Appliances'); INSERT INTO `t_video` VALUES (10053, '10003', 'I may not have gone where I intended ', 'http://video.colemb.co.jp/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10054, '10001', 'Navicat provides powerful tools ', 'https://video.xiaomingli.com/Books'); INSERT INTO `t_video` VALUES (10055, '10002', 'Navicat Cloud provides a cloud ', 'http://video.cooperjuan803.biz/Appliances'); INSERT INTO `t_video` VALUES (10056, '10001', 'If your Internet Service Provider ', 'http://video.hiutung1025.co.jp/Food'); INSERT INTO `t_video` VALUES (10057, '10002', 'You can select any connections, ', 'http://video.kolu.cn/ToolsHomeDecoration'); INSERT INTO `t_video` VALUES (10058, '10003', 'SSH serves to prevent such vulnerabilities ', 'http://video.taniguchi727.com/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10059, '10003', 'There is no way to happiness. Happiness ', 'https://video.takedaminat67.net/AppsGames'); INSERT INTO `t_video` VALUES (10060, '10003', 'A query is used to extract data ', 'http://video.yunintang.jp/MusicalInstrument'); INSERT INTO `t_video` VALUES (10061, '10003', 'The Synchronize to Database function ', 'https://video.llu.biz/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10062, '10001', 'To open a query using an external ', 'http://video.yuen6.co.jp/CollectiblesFineArt'); INSERT INTO `t_video` VALUES (10063, '10002', 'If the Show objects under schema ', 'http://video.huimeicho.biz/CenturionGardenOutdoor'); INSERT INTO `t_video` VALUES (10064, '10001', 'I destroy my enemies when I make them my friends.', 'http://video.yuitomori.cn/Beauty'); INSERT INTO `t_video` VALUES (10065, '10001', 'It provides strong authentication ', 'http://video.kondo1.biz/Others'); INSERT INTO `t_video` VALUES (10066, '10001', 'Typically, it is employed as an ', 'http://video.nantanaka10.net/IndustrialScientificSupplies'); INSERT INTO `t_video` VALUES (10067, '10001', 'Navicat Monitor can be installed ', 'http://video.konaoshi1.co.jp/ArtsHandicraftsSewing'); INSERT INTO `t_video` VALUES (10068, '10002', 'The past has no power over the present moment. ', 'http://video.yoshida205.cn/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10069, '10001', 'It provides strong authentication ', 'https://video.chiuwaiwan2.com/BaggageTravelEquipment'); INSERT INTO `t_video` VALUES (10070, '10002', 'Typically, it is employed as an ', 'https://video.kwch.xyz/ClothingShoesandJewelry'); INSERT INTO `t_video` VALUES (10071, '10001', 'There is no way to happiness. Happiness ', 'https://video.daniels74.com/BeautyPersonalCare'); INSERT INTO `t_video` VALUES (10072, '10002', 'To connect to a database or schema, ', 'https://video.tinwingmak.co.jp/BaggageTravelEquipment'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题二/db_social.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_social Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 04/12/2023 15:10:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_friendship -- ---------------------------- DROP TABLE IF EXISTS `t_friendship`; CREATE TABLE `t_friendship` ( `fsid` int(10) NOT NULL AUTO_INCREMENT `uid` int(10) NULL DEFAULT NULL `fid` int(10) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`fsid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_friendship -- ---------------------------- INSERT INTO `t_friendship` VALUES (10001 10003 10009 '2002-04-04 01:50:50'); INSERT INTO `t_friendship` VALUES (10002 10012 10005 '2001-05-20 04:00:06'); INSERT INTO `t_friendship` VALUES (10003 10009 10004 '2010-12-19 01:07:49'); INSERT INTO `t_friendship` VALUES (10004 10008 10001 '2010-02-10 10:30:30'); INSERT INTO `t_friendship` VALUES (10005 10011 10013 '2014-03-30 01:38:33'); INSERT INTO `t_friendship` VALUES (10006 10001 10020 '2007-10-08 17:28:48'); INSERT INTO `t_friendship` VALUES (10007 10019 10009 '2007-12-06 23:26:42'); INSERT INTO `t_friendship` VALUES (10008 10010 10016 '2005-03-21 12:18:51'); INSERT INTO `t_friendship` VALUES (10009 10007 10017 '2016-06-15 04:52:59'); INSERT INTO `t_friendship` VALUES (10010 10014 10004 '2007-10-26 09:36:32'); INSERT INTO `t_friendship` VALUES (10011 10018 10011 '2019-04-05 20:55:26'); INSERT INTO `t_friendship` VALUES (10012 10020 10003 '2017-03-25 13:46:34'); INSERT INTO `t_friendship` VALUES (10013 10006 10006 '2019-12-08 01:28:33'); INSERT INTO `t_friendship` VALUES (10014 10005 10014 '2000-01-30 13:45:26'); INSERT INTO `t_friendship` VALUES (10015 10017 10012 '2010-07-06 23:56:41'); INSERT INTO `t_friendship` VALUES (10016 10002 10001 '2003-11-18 02:35:48'); INSERT INTO `t_friendship` VALUES (10017 10013 10003 '2004-09-26 06:30:19'); INSERT INTO `t_friendship` VALUES (10018 10016 10013 '2016-05-06 21:42:34'); INSERT INTO `t_friendship` VALUES (10019 10004 10018 '2016-07-22 16:42:12'); INSERT INTO `t_friendship` VALUES (10020 10015 10002 '2008-08-13 11:52:14'); INSERT INTO `t_friendship` VALUES (10021 10019 10010 '2019-10-19 05:15:00'); INSERT INTO `t_friendship` VALUES (10022 10019 10017 '2015-05-17 23:29:15'); INSERT INTO `t_friendship` VALUES (10023 10018 10013 '2002-02-04 14:25:32'); INSERT INTO `t_friendship` VALUES (10024 10002 10014 '2003-05-29 06:46:36'); INSERT INTO `t_friendship` VALUES (10025 10002 10001 '2012-09-05 06:09:52'); INSERT INTO `t_friendship` VALUES (10026 10015 10016 '2019-09-21 07:11:07'); INSERT INTO `t_friendship` VALUES (10027 10010 10006 '2001-08-04 13:09:40'); INSERT INTO `t_friendship` VALUES (10028 10008 10002 '2000-05-03 01:46:48'); INSERT INTO `t_friendship` VALUES (10029 10011 10010 '2023-05-13 10:03:10'); INSERT INTO `t_friendship` VALUES (10030 10015 10010 '2023-09-18 12:05:18'); INSERT INTO `t_friendship` VALUES (10031 10003 10010 '2023-10-14 10:58:49'); INSERT INTO `t_friendship` VALUES (10032 10017 10020 '2014-01-03 07:56:10'); INSERT INTO `t_friendship` VALUES (10033 10013 10008 '2002-06-10 13:18:22'); INSERT INTO `t_friendship` VALUES (10034 10012 10011 '2004-04-26 00:18:56'); INSERT INTO `t_friendship` VALUES (10035 10017 10016 '2015-02-03 02:01:15'); INSERT INTO `t_friendship` VALUES (10036 10009 10006 '2014-04-09 05:30:28'); INSERT INTO `t_friendship` VALUES (10037 10005 10004 '2013-02-10 07:48:18'); INSERT INTO `t_friendship` VALUES (10038 10013 10020 '2022-03-03 18:35:47'); INSERT INTO `t_friendship` VALUES (10039 10020 10010 '2021-01-11 01:13:43'); INSERT INTO `t_friendship` VALUES (10040 10009 10010 '2015-11-24 22:22:40'); INSERT INTO `t_friendship` VALUES (10041 10004 10013 '2000-06-27 13:32:43'); INSERT INTO `t_friendship` VALUES (10042 10011 10002 '2020-02-01 05:44:39'); INSERT INTO `t_friendship` VALUES (10043 10018 10006 '2011-01-01 09:56:26'); INSERT INTO `t_friendship` VALUES (10044 10005 10014 '2015-02-26 02:27:57'); INSERT INTO `t_friendship` VALUES (10045 10008 10004 '2011-06-30 04:45:03'); INSERT INTO `t_friendship` VALUES (10046 10010 10013 '2013-08-22 02:37:54'); INSERT INTO `t_friendship` VALUES (10047 10001 10003 '2006-08-28 16:12:09'); INSERT INTO `t_friendship` VALUES (10048 10016 10011 '2022-03-22 03:48:39'); INSERT INTO `t_friendship` VALUES (10049 10014 10012 '2022-05-09 05:44:28'); INSERT INTO `t_friendship` VALUES (10050 10006 10002 '2020-01-06 03:24:32'); -- ---------------------------- -- Table structure for t_likes -- ---------------------------- DROP TABLE IF EXISTS `t_likes`; CREATE TABLE `t_likes` ( `lid` int(10) NOT NULL AUTO_INCREMENT `pid` int(11) NULL DEFAULT NULL `fid` int(11) NULL DEFAULT NULL `createtime` datetime NULL DEFAULT NULL PRIMARY KEY (`lid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_likes -- ---------------------------- INSERT INTO `t_likes` VALUES (10001 10032 10017 '2001-10-04 21:44:01'); INSERT INTO `t_likes` VALUES (10002 10023 10001 '2022-02-18 08:37:36'); INSERT INTO `t_likes` VALUES (10003 10009 10016 '2003-07-23 17:16:43'); INSERT INTO `t_likes` VALUES (10004 10008 10013 '2008-06-02 00:36:15'); INSERT INTO `t_likes` VALUES (10005 10011 10008 '2023-11-20 20:30:02'); INSERT INTO `t_likes` VALUES (10006 10041 10003 '2003-08-09 18:06:15'); INSERT INTO `t_likes` VALUES (10007 10026 10012 '2015-08-14 16:05:12'); INSERT INTO `t_likes` VALUES (10008 10044 10002 '2012-02-17 16:58:03'); INSERT INTO `t_likes` VALUES (10009 10038 10004 '2008-07-25 03:46:02'); INSERT INTO `t_likes` VALUES (10010 10015 10005 '2004-03-03 04:12:39'); INSERT INTO `t_likes` VALUES (10011 10047 10014 '2005-08-03 16:55:45'); INSERT INTO `t_likes` VALUES (10012 10007 10009 '2013-10-27 14:55:15'); INSERT INTO `t_likes` VALUES (10013 10027 10007 '2010-03-09 15:35:03'); INSERT INTO `t_likes` VALUES (10014 10025 10019 '2015-02-11 10:27:53'); INSERT INTO `t_likes` VALUES (10015 10022 10018 '2010-07-18 18:07:15'); INSERT INTO `t_likes` VALUES (10016 10018 10006 '2014-05-15 22:12:11'); INSERT INTO `t_likes` VALUES (10017 10045 10015 '2005-11-04 15:59:38'); INSERT INTO `t_likes` VALUES (10018 10033 10011 '2005-12-22 05:47:18'); INSERT INTO `t_likes` VALUES (10019 10001 10010 '2015-10-08 04:53:15'); INSERT INTO `t_likes` VALUES (10020 10017 10020 '2009-05-13 13:46:05'); INSERT INTO `t_likes` VALUES (10021 10019 10008 '2002-06-26 21:34:07'); INSERT INTO `t_likes` VALUES (10022 10016 10002 '2005-06-29 14:02:06'); INSERT INTO `t_likes` VALUES (10023 10003 10017 '2003-12-22 10:50:10'); INSERT INTO `t_likes` VALUES (10024 10021 10011 '2019-07-14 18:23:10'); INSERT INTO `t_likes` VALUES (10025 10034 10018 '2019-11-28 02:18:34'); INSERT INTO `t_likes` VALUES (10026 10006 10013 '2003-04-08 16:16:39'); INSERT INTO `t_likes` VALUES (10027 10048 10009 '2023-01-06 06:36:19'); INSERT INTO `t_likes` VALUES (10028 10042 10013 '2013-07-13 11:11:06'); INSERT INTO `t_likes` VALUES (10029 10036 10002 '2015-04-30 14:41:42'); INSERT INTO `t_likes` VALUES (10030 10002 10007 '2012-02-29 09:33:42'); INSERT INTO `t_likes` VALUES (10031 10037 10019 '2007-07-31 03:46:45'); INSERT INTO `t_likes` VALUES (10032 10029 10008 '2003-10-27 16:27:50'); INSERT INTO `t_likes` VALUES (10033 10012 10014 '2009-01-26 02:43:55'); INSERT INTO `t_likes` VALUES (10034 10030 10018 '2016-07-12 13:31:24'); INSERT INTO `t_likes` VALUES (10035 10035 10017 '2000-01-25 02:43:04'); INSERT INTO `t_likes` VALUES (10036 10028 10019 '2019-01-04 21:35:33'); INSERT INTO `t_likes` VALUES (10037 10031 10008 '2006-04-21 08:35:30'); INSERT INTO `t_likes` VALUES (10038 10049 10017 '2000-07-26 06:08:06'); INSERT INTO `t_likes` VALUES (10039 10004 10009 '2023-09-05 15:22:10'); INSERT INTO `t_likes` VALUES (10040 10043 10001 '2015-03-26 15:54:46'); INSERT INTO `t_likes` VALUES (10041 10005 10014 '2015-05-21 02:43:43'); INSERT INTO `t_likes` VALUES (10042 10046 10013 '2018-04-28 11:35:59'); INSERT INTO `t_likes` VALUES (10043 10024 10020 '2020-12-30 04:43:22'); INSERT INTO `t_likes` VALUES (10044 10050 10006 '2015-12-27 07:07:00'); INSERT INTO `t_likes` VALUES (10045 10014 10002 '2001-07-12 09:10:50'); INSERT INTO `t_likes` VALUES (10046 10040 10001 '2013-08-12 19:47:56'); INSERT INTO `t_likes` VALUES (10047 10039 10003 '2003-04-08 16:00:47'); INSERT INTO `t_likes` VALUES (10048 10013 10010 '2009-02-21 01:51:41'); INSERT INTO `t_likes` VALUES (10049 10010 10017 '2009-06-22 17:34:07'); INSERT INTO `t_likes` VALUES (10050 10020 10004 '2019-10-24 00:30:07'); INSERT INTO `t_likes` VALUES (10051 10037 10009 '2017-01-26 15:41:20'); INSERT INTO `t_likes` VALUES (10052 10019 10010 '2004-03-05 07:49:17'); INSERT INTO `t_likes` VALUES (10053 10024 10007 '2003-08-12 01:06:49'); INSERT INTO `t_likes` VALUES (10054 10018 10015 '2009-11-15 17:25:31'); INSERT INTO `t_likes` VALUES (10055 10011 10019 '2008-08-31 14:41:22'); INSERT INTO `t_likes` VALUES (10056 10027 10004 '2021-07-30 12:50:58'); INSERT INTO `t_likes` VALUES (10057 10040 10012 '2009-06-18 03:32:59'); INSERT INTO `t_likes` VALUES (10058 10041 10011 '2005-07-15 08:40:49'); INSERT INTO `t_likes` VALUES (10059 10027 10001 '2023-11-03 00:16:59'); INSERT INTO `t_likes` VALUES (10060 10017 10003 '2022-01-09 05:57:27'); INSERT INTO `t_likes` VALUES (10061 10025 10005 '2003-02-11 00:42:46'); INSERT INTO `t_likes` VALUES (10062 10021 10004 '2016-07-31 05:26:24'); INSERT INTO `t_likes` VALUES (10063 10036 10012 '2005-02-21 01:16:20'); INSERT INTO `t_likes` VALUES (10064 10017 10019 '2023-01-30 23:58:39'); INSERT INTO `t_likes` VALUES (10065 10026 10013 '2022-08-03 04:41:12'); INSERT INTO `t_likes` VALUES (10066 10007 10014 '2004-02-06 13:25:20'); INSERT INTO `t_likes` VALUES (10067 10007 10018 '2023-10-29 12:47:27'); INSERT INTO `t_likes` VALUES (10068 10039 10020 '2016-09-27 15:00:18'); INSERT INTO `t_likes` VALUES (10069 10046 10015 '2015-05-06 03:39:44'); INSERT INTO `t_likes` VALUES (10070 10002 10007 '2016-02-05 05:48:52'); INSERT INTO `t_likes` VALUES (10071 10047 10002 '2015-03-18 13:22:58'); INSERT INTO `t_likes` VALUES (10072 10021 10011 '2002-12-21 21:16:38'); INSERT INTO `t_likes` VALUES (10073 10040 10017 '2018-01-28 02:31:12'); INSERT INTO `t_likes` VALUES (10074 10050 10008 '2022-12-27 15:45:29'); INSERT INTO `t_likes` VALUES (10075 10005 10010 '2010-10-12 06:34:09'); INSERT INTO `t_likes` VALUES (10076 10050 10002 '2021-08-21 22:27:44'); INSERT INTO `t_likes` VALUES (10077 10044 10017 '2004-04-07 10:52:28'); INSERT INTO `t_likes` VALUES (10078 10030 10015 '2013-07-11 19:36:53'); INSERT INTO `t_likes` VALUES (10079 10010 10008 '2018-09-07 11:29:25'); INSERT INTO `t_likes` VALUES (10080 10014 10006 '2002-01-31 00:05:49'); INSERT INTO `t_likes` VALUES (10081 10011 10010 '2021-10-19 00:55:37'); INSERT INTO `t_likes` VALUES (10082 10018 10016 '2000-03-10 09:20:16'); INSERT INTO `t_likes` VALUES (10083 10012 10007 '2009-03-22 19:06:25'); INSERT INTO `t_likes` VALUES (10084 10006 10009 '2016-09-18 14:11:18'); INSERT INTO `t_likes` VALUES (10085 10008 10012 '2010-11-20 08:14:55'); INSERT INTO `t_likes` VALUES (10086 10043 10004 '2008-02-27 12:30:05'); INSERT INTO `t_likes` VALUES (10087 10030 10003 '2000-03-29 07:18:02'); INSERT INTO `t_likes` VALUES (10088 10026 10018 '2016-02-23 23:15:54'); INSERT INTO `t_likes` VALUES (10089 10048 10017 '2006-10-05 01:59:59'); INSERT INTO `t_likes` VALUES (10090 10044 10008 '2020-09-09 00:03:47'); INSERT INTO `t_likes` VALUES (10091 10008 10018 '2020-08-29 18:22:05'); INSERT INTO `t_likes` VALUES (10092 10009 10012 '2019-10-31 01:59:48'); INSERT INTO `t_likes` VALUES (10093 10025 10013 '2011-03-16 13:02:56'); INSERT INTO `t_likes` VALUES (10094 10043 10006 '2023-10-22 19:31:52'); INSERT INTO `t_likes` VALUES (10095 10001 10020 '2011-07-23 22:21:20'); INSERT INTO `t_likes` VALUES (10096 10034 10008 '2006-11-08 11:59:44'); INSERT INTO `t_likes` VALUES (10097 10024 10003 '2021-04-06 01:14:15'); INSERT INTO `t_likes` VALUES (10098 10039 10014 '2019-06-16 04:55:10'); INSERT INTO `t_likes` VALUES (10099 10032 10001 '2007-11-02 19:19:16'); INSERT INTO `t_likes` VALUES (10100 10029 10020 '2014-02-04 05:11:29'); -- ---------------------------- -- Table structure for t_post -- ---------------------------- DROP TABLE IF EXISTS `t_post`; CREATE TABLE `t_post` ( `pid` int(10) NOT NULL AUTO_INCREMENT `uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `createtime` date NULL DEFAULT NULL PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_post -- ---------------------------- INSERT INTO `t_post` VALUES (10001 '10003' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab.' '2020-10-04'); INSERT INTO `t_post` VALUES (10002 '10006' 'You will succeed because most people are lazy. Creativity is intelligence having fun. The Main Window consists of several toolbars and panes for you to work on connections database objects and advanced tools.' '2014-07-10'); INSERT INTO `t_post` VALUES (10003 '10011' 'Flexible settings enable you to set up a custom key for comparison and synchronization. The first step is as good as half over. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port ' '2007-06-05'); INSERT INTO `t_post` VALUES (10004 '10002' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information. SSH serves to prevent such vulnerabilities ' '2000-03-20'); INSERT INTO `t_post` VALUES (10005 '10019' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed ' '2021-05-19'); INSERT INTO `t_post` VALUES (10006 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2013-07-27'); INSERT INTO `t_post` VALUES (10007 '10012' 'You must be the change you wish to see in the world. Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords ' '2016-05-17'); INSERT INTO `t_post` VALUES (10008 '10010' 'It is used while your ISPs do not allow direct connections but allows establishing HTTP connections. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Instead of wondering when your next vacation ' '2013-06-26'); INSERT INTO `t_post` VALUES (10009 '10017' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2014-03-09'); INSERT INTO `t_post` VALUES (10010 '10018' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Cloud provides a cloud service for synchronizing connections queries model files and virtual group information ' '2017-08-24'); INSERT INTO `t_post` VALUES (10011 '10008' 'Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. If you wait all that happens is you get older.' '2013-01-01'); INSERT INTO `t_post` VALUES (10012 '10007' 'You cannot save people you can just love them. Typically it is employed as an encrypted version of Telnet. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up ' '2015-12-09'); INSERT INTO `t_post` VALUES (10013 '10001' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If your Internet Service Provider (ISP) does not provide direct access to its server Secure ' '2007-04-07'); INSERT INTO `t_post` VALUES (10014 '10020' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Champions keep playing until they get it right. Navicat 15 has added support for the system-wide dark mode.' '2012-01-31'); INSERT INTO `t_post` VALUES (10015 '10014' 'A man’s best friends are his ten fingers. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. What you get by achieving your goals is not as ' '2015-01-04'); INSERT INTO `t_post` VALUES (10016 '10015' 'Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or MongoDB databases making database administration to multiple kinds of database so easy.' '2013-08-24'); INSERT INTO `t_post` VALUES (10017 '10016' 'Actually it is just in an idea when feel oneself can achieve and cannot achieve. A man is not old until regrets take the place of dreams.' '2008-07-11'); INSERT INTO `t_post` VALUES (10018 '10013' 'The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles and preview.' '2006-12-28'); INSERT INTO `t_post` VALUES (10019 '10004' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2013-07-30'); INSERT INTO `t_post` VALUES (10020 '10005' 'HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. A man is not old until regrets take the place of dreams.' '2023-09-01'); INSERT INTO `t_post` VALUES (10021 '10007' 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. There is no way to happiness. Happiness is the way. The reason why a great man is great is that he resolves to be a great man.' '2018-01-18'); INSERT INTO `t_post` VALUES (10022 '10006' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration.' '2001-11-07'); INSERT INTO `t_post` VALUES (10023 '10019' 'Genius is an infinite capacity for taking pains. Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2022-04-06'); INSERT INTO `t_post` VALUES (10024 '10012' 'If your Internet Service Provider (ISP) does not provide direct access to its server Secure Tunneling Protocol (SSH) / HTTP is another solution. What you get by achieving your goals is not as important as what you become by achieving your goals.' '2002-07-07'); INSERT INTO `t_post` VALUES (10025 '10014' 'If you wait all that happens is you get older. With its well-designed Graphical User Interface(GUI) Navicat lets you quickly and easily create organize access and share information in a secure and easy way.' '2004-06-25'); INSERT INTO `t_post` VALUES (10026 '10004' 'To clear or reload various internal caches flush tables or acquire locks control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature.' '2004-05-09'); INSERT INTO `t_post` VALUES (10027 '10005' 'I may not have gone where I intended to go but I think I have ended up where I needed to be. A comfort zone is a beautiful place but nothing ever grows there.' '2003-08-15'); INSERT INTO `t_post` VALUES (10028 '10006' 'Champions keep playing until they get it right. Remember that failure is an event not a person. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual logical and physical data models.' '2016-10-28'); INSERT INTO `t_post` VALUES (10029 '10010' 'What you get by achieving your goals is not as important as what you become by achieving your goals. After logged in the Navicat Cloud feature the Navigation pane will be divided into Navicat Cloud and My Connections sections.' '2021-10-29'); INSERT INTO `t_post` VALUES (10030 '10014' 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH set the database login information in the General tab. If the Show objects under schema in navigation pane option is checked at the Preferences ' '2007-03-17'); INSERT INTO `t_post` VALUES (10031 '10001' 'If it scares you it might be a good thing to try. I destroy my enemies when I make them my friends. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does.' '2005-12-06'); INSERT INTO `t_post` VALUES (10032 '10019' 'You can select any connections objects or projects and then select the corresponding buttons on the Information Pane. Navicat Monitor requires a repository to store alerts and metrics for historical analysis.' '2014-12-11'); INSERT INTO `t_post` VALUES (10033 '10018' 'Creativity is intelligence having fun. I destroy my enemies when I make them my friends. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL Oracle PostgreSQL SQLite SQL Server MariaDB and/or ' '2017-03-22'); INSERT INTO `t_post` VALUES (10034 '10012' 'To connect to a database or schema simply double-click it in the pane. Flexible settings enable you to set up a custom key for comparison and synchronization. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2022-11-13'); INSERT INTO `t_post` VALUES (10035 '10017' 'If the Show objects under schema in navigation pane option is checked at the Preferences window all database objects are also displayed in the pane. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. ' '2012-02-23'); INSERT INTO `t_post` VALUES (10036 '10008' 'Optimism is the one quality more associated with success and happiness than any other. A query is used to extract data from the database in a readable format according to the user\'s request.' '2005-12-16'); INSERT INTO `t_post` VALUES (10037 '10002' 'The past has no power over the present moment. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored.' '2016-04-13'); INSERT INTO `t_post` VALUES (10038 '10010' 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. It collects process metrics such as CPU load RAM usage and a variety of other resources over SSH/SNMP.' '2010-10-20'); INSERT INTO `t_post` VALUES (10039 '10003' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network.' '2019-07-20'); INSERT INTO `t_post` VALUES (10040 '10020' 'Optimism is the one quality more associated with success and happiness than any other. In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session ' '2003-11-25'); INSERT INTO `t_post` VALUES (10041 '10007' 'Creativity is intelligence having fun. A comfort zone is a beautiful place but nothing ever grows there. After comparing data the window shows the number of records that will be inserted updated or deleted in the target.' '2003-03-21'); INSERT INTO `t_post` VALUES (10042 '10001' 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Genius is an infinite capacity for taking pains. Anyone who has ever made anything of importance was disciplined.' '2000-03-30'); INSERT INTO `t_post` VALUES (10043 '10002' 'Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet.' '2013-12-21'); INSERT INTO `t_post` VALUES (10044 '10016' 'In a Telnet session all communications including username and password are transmitted in plain-text allowing anyone to listen-in on your session and steal passwords and other information.' '2016-03-25'); INSERT INTO `t_post` VALUES (10045 '10009' 'It can also manage cloud databases such as Amazon Redshift Amazon RDS Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs yet easy to learn for users who are new ' '2004-03-05'); INSERT INTO `t_post` VALUES (10046 '10017' 'It provides strong authentication and secure encrypted communications between two hosts known as SSH Port Forwarding (Tunneling) over an insecure network. How we spend our days is of course how we spend our lives. I may not have gone ' '2015-07-06'); INSERT INTO `t_post` VALUES (10047 '10013' 'Navicat Monitor requires a repository to store alerts and metrics for historical analysis. The Information Pane shows the detailed object information project activities the DDL of database objects object dependencies membership of users/roles ' '2016-09-13'); INSERT INTO `t_post` VALUES (10048 '10016' 'Navicat Monitor is a safe simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.' '2005-01-10'); INSERT INTO `t_post` VALUES (10049 '10020' 'You cannot save people you can just love them. The On Startup feature allows you to control what tabs appear when you launch Navicat. Import Wizard allows you to import data to tables/collections from CSV TXT XML DBF and more.' '2010-05-16'); INSERT INTO `t_post` VALUES (10050 '10015' 'Navicat Cloud could not connect and access your databases. By which it means it could only store your connection settings queries model files and virtual group; your database passwords and data (e.g. tables views etc) will not be ' '2004-04-21'); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `uid` int(10) NOT NULL AUTO_INCREMENT `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL `age` int(3) NULL DEFAULT NULL `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL PRIMARY KEY (`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (10001 'RcZMBygzEP' 'KAc0k5N7ik' 'Kimberly' 31 '女'); INSERT INTO `t_user` VALUES (10002 'xZbFVNFPfC' 'YGQPYvApoW' 'Betty' 19 '女'); INSERT INTO `t_user` VALUES (10003 'rWQkglfDHp' 'a090zWktf2' 'Barry' 43 'ç”·'); INSERT INTO `t_user` VALUES (10004 'AsWnNuQrBn' 'AzS6Fiv4TD' 'Randy' 49 'ç”·'); INSERT INTO `t_user` VALUES (10005 'ydPZCqwaWz' 'SwOjHxNc29' 'Amy' 30 '女'); INSERT INTO `t_user` VALUES (10006 'egikGPKoHB' '0IyNHa4ACw' 'Ruth' 33 '女'); INSERT INTO `t_user` VALUES (10007 'AWxdiAksDt' 'j6vFisZKc1' 'April' 38 '女'); INSERT INTO `t_user` VALUES (10008 'aUTVurILei' 'bPxFeeKhy8' 'Cynthia' 38 '女'); INSERT INTO `t_user` VALUES (10009 'RcOgLMMata' 'AxhUsVUU78' 'Tammy' 20 '女'); INSERT INTO `t_user` VALUES (10010 'iRnxECjbol' 'QCfHAiimrG' 'Alice' 15 '女'); INSERT INTO `t_user` VALUES (10011 'FhqYITqTdA' 'dVNCEepBKC' 'Thelma' 46 '女'); INSERT INTO `t_user` VALUES (10012 'hBFObiRjOn' 'qoKKRgbYzO' 'Bradley' 27 'ç”·'); INSERT INTO `t_user` VALUES (10013 'nOLwlDpyIN' 'tGuW0T5FcG' 'Jean' 28 '女'); INSERT INTO `t_user` VALUES (10014 'VYhKLehGcy' 'phKBleXEQ9' 'Jose' 44 'ç”·'); INSERT INTO `t_user` VALUES (10015 'ybKBizSikJ' 'l7sRDLObVU' 'Daniel' 48 'ç”·'); INSERT INTO `t_user` VALUES (10016 'uvOZOdSvbV' 'eYmVqLJm3z' 'Rosa' 22 '女'); INSERT INTO `t_user` VALUES (10017 'OHZBeflocp' '8O8DZeCB9R' 'Tony' 44 'ç”·'); INSERT INTO `t_user` VALUES (10018 'gHfroIcoQc' '63USEuGBeB' 'Thomas' 16 'ç”·'); INSERT INTO `t_user` VALUES (10019 'HRQGdchgoS' 'apvalUkIbQ' 'Kelly' 17 '女'); INSERT INTO `t_user` VALUES (10020 'tBFVIvbDgj' 'IwcjzMg9xB' 'Steven' 33 'ç”·'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《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: 05/12/2023 10:57:18 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_doctor -- ---------------------------- DROP TABLE IF EXISTS `t_doctor`; CREATE TABLE `t_doctor` ( `did` int(10) NOT NULL AUTO_INCREMENT, `dname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `office` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`did`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10021 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_doctor -- ---------------------------- INSERT INTO `t_doctor` VALUES (10001, '孟睿', '外科', '实习医生', '196-1142-8607'); INSERT INTO `t_doctor` VALUES (10002, '孙云熙', '耳鼻喉科', '实习医生', '133-0211-7241'); INSERT INTO `t_doctor` VALUES (10003, '邹岚', '内科', '高级医生', '10-560-1386'); INSERT INTO `t_doctor` VALUES (10004, '周子异', '外科', '实习医生', '199-8805-8963'); INSERT INTO `t_doctor` VALUES (10005, '朱睿', '外科', '中级医生', '191-5127-0466'); INSERT INTO `t_doctor` VALUES (10006, '常安琪', '耳鼻喉科', '实习医生', '755-780-8243'); INSERT INTO `t_doctor` VALUES (10007, '崔秀英', '儿科', '主任', '186-1296-4216'); INSERT INTO `t_doctor` VALUES (10008, '董詩涵', '外科', '主任', '760-5492-7849'); INSERT INTO `t_doctor` VALUES (10009, '崔秀英', '内科', '中级医生', '10-1750-7240'); INSERT INTO `t_doctor` VALUES (10010, '周睿', '耳鼻喉科', '高级医生', '755-834-7691'); INSERT INTO `t_doctor` VALUES (10011, '卢震南', '儿科', '中级医生', '186-5900-0614'); INSERT INTO `t_doctor` VALUES (10012, '雷震南', '耳鼻喉科', '高级医生', '178-6511-9350'); INSERT INTO `t_doctor` VALUES (10013, '雷岚', '儿科', '实习医生', '190-6306-4361'); INSERT INTO `t_doctor` VALUES (10014, '唐云熙', '内科', '中级医生', '755-0855-7704'); INSERT INTO `t_doctor` VALUES (10015, '郑震南', '儿科', '中级医生', '20-8721-5863'); INSERT INTO `t_doctor` VALUES (10016, '贾杰宏', '内科', '主任', '130-1162-3953'); INSERT INTO `t_doctor` VALUES (10017, '任睿', '耳鼻喉科', '主任', '21-4613-2793'); INSERT INTO `t_doctor` VALUES (10018, '侯安琪', '内科', '中级医生', '769-867-7575'); INSERT INTO `t_doctor` VALUES (10019, '郝杰宏', '儿科', '实习医生', '21-638-0661'); INSERT INTO `t_doctor` VALUES (10020, '秦晓明', '内科', '中级医生', '178-0882-6094'); -- ---------------------------- -- Table structure for t_patient -- ---------------------------- DROP TABLE IF EXISTS `t_patient`; CREATE TABLE `t_patient` ( `pid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(5) NULL DEFAULT NULL, `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`pid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_patient -- ---------------------------- INSERT INTO `t_patient` VALUES ('10001', '严子韬', '男', 30, '178-8729-5799'); INSERT INTO `t_patient` VALUES ('10002', '蔡詩涵', '女', 17, '755-6590-9717'); INSERT INTO `t_patient` VALUES ('10003', '蔡嘉伦', '男', 31, '147-0244-7071'); INSERT INTO `t_patient` VALUES ('10004', '卢安琪', '女', 19, '28-018-1654'); INSERT INTO `t_patient` VALUES ('10005', '许宇宁', '男', 57, '139-8471-7072'); INSERT INTO `t_patient` VALUES ('10006', '彭璐', '女', 56, '144-0250-4252'); INSERT INTO `t_patient` VALUES ('10007', '李睿', '男', 11, '760-5963-6579'); INSERT INTO `t_patient` VALUES ('10008', '叶宇宁', '男', 33, '155-1117-9875'); INSERT INTO `t_patient` VALUES ('10009', '杨睿', '男', 48, '760-1389-9772'); INSERT INTO `t_patient` VALUES ('10010', '熊致远', '男', 11, '20-9278-7287'); INSERT INTO `t_patient` VALUES ('10011', '谭子韬', '男', 11, '10-5460-3302'); INSERT INTO `t_patient` VALUES ('10012', '龙云熙', '男', 36, '769-625-8369'); INSERT INTO `t_patient` VALUES ('10013', '潘睿', '男', 15, '146-5460-0503'); INSERT INTO `t_patient` VALUES ('10014', '胡嘉伦', '男', 23, '144-0725-3728'); INSERT INTO `t_patient` VALUES ('10015', '陶睿', '男', 50, '144-4354-4812'); INSERT INTO `t_patient` VALUES ('10016', '顾震南', '男', 33, '755-837-7148'); INSERT INTO `t_patient` VALUES ('10017', '袁岚', '女', 49, '173-5836-5107'); INSERT INTO `t_patient` VALUES ('10018', '卢詩涵', '女', 58, '760-176-4450'); INSERT INTO `t_patient` VALUES ('10019', '李璐', '女', 22, '20-8392-9908'); INSERT INTO `t_patient` VALUES ('10020', '蔡詩涵', '女', 27, '190-8099-9579'); INSERT INTO `t_patient` VALUES ('10021', '吕子异', '男', 23, '28-205-6374'); INSERT INTO `t_patient` VALUES ('10022', '侯詩涵', '女', 25, '20-4328-8586'); INSERT INTO `t_patient` VALUES ('10023', '孔睿', '男', 58, '769-118-9579'); INSERT INTO `t_patient` VALUES ('10024', '徐嘉伦', '男', 33, '21-0131-1452'); INSERT INTO `t_patient` VALUES ('10025', '傅安琪', '女', 17, '760-074-2030'); INSERT INTO `t_patient` VALUES ('10026', '蒋致远', '男', 49, '154-1502-8322'); INSERT INTO `t_patient` VALUES ('10027', '何云熙', '男', 11, '760-7767-9468'); INSERT INTO `t_patient` VALUES ('10028', '朱秀英', '女', 57, '28-951-6412'); INSERT INTO `t_patient` VALUES ('10029', '萧睿', '男', 16, '169-1837-9488'); INSERT INTO `t_patient` VALUES ('10030', '苏宇宁', '男', 28, '769-6418-4954'); INSERT INTO `t_patient` VALUES ('10031', '马睿', '男', 44, '21-868-2371'); INSERT INTO `t_patient` VALUES ('10032', '吴晓明', '男', 46, '138-8679-0662'); INSERT INTO `t_patient` VALUES ('10033', '汪震南', '男', 55, '156-1029-5325'); INSERT INTO `t_patient` VALUES ('10034', '陆嘉伦', '男', 12, '755-081-8243'); INSERT INTO `t_patient` VALUES ('10035', '韩致远', '男', 14, '28-3673-8413'); INSERT INTO `t_patient` VALUES ('10036', '陶詩涵', '女', 42, '185-8722-8093'); INSERT INTO `t_patient` VALUES ('10037', '秦璐', '女', 60, '769-275-5209'); INSERT INTO `t_patient` VALUES ('10038', '余致远', '男', 20, '179-1132-3645'); INSERT INTO `t_patient` VALUES ('10039', '梁云熙', '男', 39, '21-7784-6260'); INSERT INTO `t_patient` VALUES ('10040', '刘晓明', '男', 50, '143-5309-6600'); INSERT INTO `t_patient` VALUES ('10041', '贺杰宏', '男', 14, '760-9388-2272'); INSERT INTO `t_patient` VALUES ('10042', '廖子异', '男', 54, '10-700-0511'); INSERT INTO `t_patient` VALUES ('10043', '邵致远', '男', 45, '769-970-5598'); INSERT INTO `t_patient` VALUES ('10044', '常子韬', '男', 44, '142-2894-9338'); INSERT INTO `t_patient` VALUES ('10045', '龚睿', '男', 42, '760-8312-1246'); INSERT INTO `t_patient` VALUES ('10046', '雷秀英', '女', 34, '755-2071-2097'); INSERT INTO `t_patient` VALUES ('10047', '钟晓明', '男', 55, '769-301-9665'); INSERT INTO `t_patient` VALUES ('10048', '黎致远', '男', 39, '20-9401-0460'); INSERT INTO `t_patient` VALUES ('10049', '马杰宏', '男', 44, '142-4147-4122'); INSERT INTO `t_patient` VALUES ('10050', '魏云熙', '男', 35, '21-6786-3131'); -- ---------------------------- -- Table structure for t_registration -- ---------------------------- DROP TABLE IF EXISTS `t_registration`; CREATE TABLE `t_registration` ( `rid` int(10) NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL, `did` int(10) NULL DEFAULT NULL, `rtime` date NULL DEFAULT NULL, PRIMARY KEY (`rid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 490051 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_registration -- ---------------------------- INSERT INTO `t_registration` VALUES (1, 10007, 10001, '2006-12-31'); INSERT INTO `t_registration` VALUES (10002, 10049, 10011, '2017-07-12'); INSERT INTO `t_registration` VALUES (20003, 10037, 10013, '2004-05-08'); INSERT INTO `t_registration` VALUES (30004, 10005, 10018, '2001-02-22'); INSERT INTO `t_registration` VALUES (40005, 10039, 10015, '2021-04-24'); INSERT INTO `t_registration` VALUES (50006, 10011, 10011, '2019-05-11'); INSERT INTO `t_registration` VALUES (60007, 10035, 10002, '2010-02-10'); INSERT INTO `t_registration` VALUES (70008, 10018, 10005, '2000-03-18'); INSERT INTO `t_registration` VALUES (80009, 10032, 10005, '2021-04-01'); INSERT INTO `t_registration` VALUES (90010, 10034, 10009, '2007-03-04'); INSERT INTO `t_registration` VALUES (100011, 10014, 10013, '2022-12-28'); INSERT INTO `t_registration` VALUES (110012, 10026, 10015, '2018-04-25'); INSERT INTO `t_registration` VALUES (120013, 10009, 10019, '2011-09-05'); INSERT INTO `t_registration` VALUES (130014, 10021, 10007, '2015-09-24'); INSERT INTO `t_registration` VALUES (140015, 10020, 10004, '2013-10-02'); INSERT INTO `t_registration` VALUES (150016, 10013, 10009, '2016-11-15'); INSERT INTO `t_registration` VALUES (160017, 10038, 10013, '2018-10-03'); INSERT INTO `t_registration` VALUES (170018, 10044, 10012, '2018-03-07'); INSERT INTO `t_registration` VALUES (180019, 10048, 10003, '2004-08-09'); INSERT INTO `t_registration` VALUES (190020, 10043, 10012, '2017-05-18'); INSERT INTO `t_registration` VALUES (200021, 10016, 10017, '2011-10-07'); INSERT INTO `t_registration` VALUES (210022, 10012, 10005, '2005-12-14'); INSERT INTO `t_registration` VALUES (220023, 10010, 10004, '2018-07-20'); INSERT INTO `t_registration` VALUES (230024, 10002, 10011, '2023-11-06'); INSERT INTO `t_registration` VALUES (240025, 10017, 10010, '2016-11-26'); INSERT INTO `t_registration` VALUES (250026, 10033, 10011, '2004-12-03'); INSERT INTO `t_registration` VALUES (260027, 10022, 10020, '2005-09-12'); INSERT INTO `t_registration` VALUES (270028, 10040, 10015, '2012-02-08'); INSERT INTO `t_registration` VALUES (280029, 10008, 10010, '2023-08-05'); INSERT INTO `t_registration` VALUES (290030, 10045, 10013, '2009-01-15'); INSERT INTO `t_registration` VALUES (300031, 10028, 10010, '2005-10-26'); INSERT INTO `t_registration` VALUES (310032, 10024, 10016, '2007-02-05'); INSERT INTO `t_registration` VALUES (320033, 10006, 10012, '2005-01-09'); INSERT INTO `t_registration` VALUES (330034, 10036, 10009, '2012-07-04'); INSERT INTO `t_registration` VALUES (340035, 10015, 10010, '2016-01-14'); INSERT INTO `t_registration` VALUES (350036, 10025, 10007, '2007-07-16'); INSERT INTO `t_registration` VALUES (360037, 10046, 10009, '2003-11-21'); INSERT INTO `t_registration` VALUES (370038, 10042, 10019, '2015-08-22'); INSERT INTO `t_registration` VALUES (380039, 10047, 10008, '2003-12-11'); INSERT INTO `t_registration` VALUES (390040, 10030, 10011, '2023-11-03'); INSERT INTO `t_registration` VALUES (400041, 10041, 10011, '2009-10-31'); INSERT INTO `t_registration` VALUES (410042, 10001, 10015, '2016-01-28'); INSERT INTO `t_registration` VALUES (420043, 10029, 10020, '2001-01-31'); INSERT INTO `t_registration` VALUES (430044, 10050, 10018, '2015-06-07'); INSERT INTO `t_registration` VALUES (440045, 10031, 10018, '2011-11-30'); INSERT INTO `t_registration` VALUES (450046, 10003, 10004, '2022-06-13'); INSERT INTO `t_registration` VALUES (460047, 10004, 10002, '2017-07-12'); INSERT INTO `t_registration` VALUES (470048, 10027, 10003, '2005-07-13'); INSERT INTO `t_registration` VALUES (480049, 10023, 10019, '2015-05-13'); INSERT INTO `t_registration` VALUES (490050, 10019, 10007, '2011-09-14'); SET FOREIGN_KEY_CHECKS = 1; 期末复习卷《MySQL数据库基础》（上海科学普及出版社）（一）（素材）/题四/db_grade.myd /* Navicat MySQL Data Transfer Source Server : 1 Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host : localhost:3306 Source Schema : db_grade Target Server Type : MySQL Target Server Version : 50743 (5.7.43-log) File Encoding : 65001 Date: 23/11/2023 15:31:23 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_course -- ---------------------------- DROP TABLE IF EXISTS `t_course`; CREATE TABLE `t_course` ( `cid` int(11) NOT NULL, `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `total` int(5) NULL DEFAULT NULL, PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_course -- ---------------------------- INSERT INTO `t_course` VALUES (10001, '英语', 150); INSERT INTO `t_course` VALUES (10002, '语文', 150); INSERT INTO `t_course` VALUES (10003, '数学', 150); -- ---------------------------- -- Table structure for t_grade -- ---------------------------- DROP TABLE IF EXISTS `t_grade`; CREATE TABLE `t_grade` ( `gid` int(10) NOT NULL, `sid` int(10) NOT NULL, `cid` int(10) NOT NULL, `score` int(10) NULL DEFAULT NULL, PRIMARY KEY (`gid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_grade -- ---------------------------- INSERT INTO `t_grade` VALUES (10001, 10010, 10003, 53); INSERT INTO `t_grade` VALUES (10002, 10001, 10002, 52); INSERT INTO `t_grade` VALUES (10003, 10007, 10003, 53); INSERT INTO `t_grade` VALUES (10004, 10001, 10001, 124); INSERT INTO `t_grade` VALUES (10005, 10003, 10003, 119); INSERT INTO `t_grade` VALUES (10006, 10003, 10002, 145); INSERT INTO `t_grade` VALUES (10007, 10008, 10002, 109); INSERT INTO `t_grade` VALUES (10008, 10006, 10002, 101); INSERT INTO `t_grade` VALUES (10009, 10003, 10001, 128); INSERT INTO `t_grade` VALUES (10010, 10002, 10001, 110); INSERT INTO `t_grade` VALUES (10011, 10002, 10003, 146); INSERT INTO `t_grade` VALUES (10012, 10007, 10001, 132); INSERT INTO `t_grade` VALUES (10013, 10010, 10001, 126); INSERT INTO `t_grade` VALUES (10014, 10010, 10002, 104); INSERT INTO `t_grade` VALUES (10015, 10006, 10001, 109); INSERT INTO `t_grade` VALUES (10016, 10001, 10003, 99); INSERT INTO `t_grade` VALUES (10017, 10002, 10002, 138); INSERT INTO `t_grade` VALUES (10018, 10006, 10003, 105); INSERT INTO `t_grade` VALUES (10019, 10008, 10001, 141); INSERT INTO `t_grade` VALUES (10020, 10005, 10002, 90); INSERT INTO `t_grade` VALUES (10021, 10004, 10003, 54); INSERT INTO `t_grade` VALUES (10022, 10005, 10003, 86); INSERT INTO `t_grade` VALUES (10023, 10009, 10001, 138); INSERT INTO `t_grade` VALUES (10024, 10005, 10001, 126); INSERT INTO `t_grade` VALUES (10025, 10007, 10002, 111); INSERT INTO `t_grade` VALUES (10026, 10009, 10003, 120); INSERT INTO `t_grade` VALUES (10027, 10004, 10002, 103); INSERT INTO `t_grade` VALUES (10028, 10009, 10002, 125); INSERT INTO `t_grade` VALUES (10029, 10004, 10001, 87); INSERT INTO `t_grade` VALUES (10030, 10008, 10003, 51); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `sid` int(11) NOT NULL AUTO_INCREMENT, `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES (10001, '夏震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10002, '孔璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10003, '田璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10004, '田秀英', '女', '高二3班'); INSERT INTO `t_student` VALUES (10005, '宋詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10006, '薛詩涵', '女', '高二3班'); INSERT INTO `t_student` VALUES (10007, '石震南', '男', '高二3班'); INSERT INTO `t_student` VALUES (10008, '梁致远', '男', '高二3班'); INSERT INTO `t_student` VALUES (10009, '顾璐', '女', '高二3班'); INSERT INTO `t_student` VALUES (10010, '魏晓明', '男', '高二3班'); SET FOREIGN_KEY_CHECKS = 1; $