期末复习卷《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_viewing,字段如下: vid(看房编号) char(10) 主键, cid(客户编号) char(10) 非空, hid(房屋编号) char(10) 非空, viewtime(看房时间) datetime, remark(备注) varchar(100) 2).向t_viewing表中插入一条数据:看房编号 v0002,客户编号 c0008,房屋编号 h0010,看房时间 2025-06-15 10:00:00 3).为t_client表添加viplevel字段(会员等级),类型 int,默认0 4).将t_house表中房屋编号 h0012 的联系电话修改为 13912345678 5).查询价格在2000到3500之间且面积大于 70 平方米的所有房屋信息 6).查询客户李华的所有订单,显示客户姓名、房屋地址、租赁时间 7).创建视图v_house_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_favorite,字段如下: favid(收藏编号) char(10) 主键, pid(动态编号) char(10) 非空, uid(用户编号) char(10) 非空, favtime(收藏时间) datetime 2).向t_favorite表中插入一条数据:收藏编号 f0003,动态编号 p0010,用户编号 u0020,收藏时间 2025-05-20 12:00:00 3).为t_post表添加likecount字段(点赞数),类型 int,默认 0 4).将t_user表中用户编号 u0015 的年龄修改为 22 5).查询性别为男且年龄大于 20 岁的所有用户信息 6).查询用户王丽的所有好友昵称和添加时间 7).创建视图v_user_post,显示用户动态:昵称、动态内容、发布时间 8).创建触发器:当删除一条动态时,自动删除该动态下的所有点赞记录 9).创建存储过程proc_unfriend,输入两个用户编号,实现双向删除好友 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_review,字段如下: rid(评价编号) char(10) 主键, cid(课程编号) char(10) 非空, sid(学生编号) char(10) 非空, score(评分) int, content(评价内容) text 2).向t_review表中插入一条数据:评价编号r0005,课程编号 c0010,学生编号 s0012,评分 95,内容讲得很好 3).为t_course表添加teacher字段(授课教师),类型varchar(50) 4).将t_video表中课程编号 c0008 的视频链接修改为data:http://www.test.com 5).查询课时大于 40 的所有课程信息 6).查询学生张伟学习的所有课程,显示学生姓名、课程名称、学习进度 7).创建视图v_student_course,显示学生选课情况:学生姓名、班级、课程名称、课时 8).创建触发器:当删除一个课程时,自动删除该课程下的所有视频和学习记录 9).创建存储过程proc_course_student_count,输入课程编号,返回该课程的学生学习人数 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_exam,字段如下: eid(考试编号) char(10) 主键, sid(学生编号) char(10) 非空, cid(科目编号) char(10) 非空, examscore(考试成绩) decimal(5,2), examdate(考试日期) date 2).向t_exam表中插入一条数据:考试编号 e0010,学生编号 s0030,科目编号 c0020,考试成绩 88.5,考试日期 2025-07-01 3).为t_student表添加enrollment字段(入学年份),类型 year 4).将t_course表中科目编号 c0015 的科目名称修改为高等数学 5).查询总分大于 100 的所有科目信息 6).查询班级为高二1班的学生中英语成绩大于 80 分的学生姓名和英语成绩 7).创建视图v_exam_rank,显示考试排名:学生姓名、科目名称、考试成绩 8).创建触发器:当插入或更新考试成绩时,自动更新该科目的平均分 9).创建存储过程proc_student_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_medicine,字段如下: mid(药品编号) char(10) 主键, mname(药品名称) varchar(50), price(价格) decimal(8,2), stock(库存量) int 2).向t_medicine表中插入一条数据:药品编号 m0010,药品名称布洛芬,价格 25.00,库存 100 3).为t_registration表添加fee字段(挂号费),类型 decimal(6,2),默认 10.00 4).将t_patient表中患者编号 p0020 的联系电话修改为 15987654321 5).查询年龄大于 60 岁的所有患者信息 6).查询医生张三的所有挂号患者,显示患者姓名、挂号日期、医生姓名 7).创建视图v_patient_medical,显示患者病历:患者姓名、医生姓名、诊断结果、就诊时间 8).创建触发器:当插入一条挂号记录时,自动将挂号费累加到该医生当天总收入 9).创建存储过程proc_today_patients,输入医生编号和日期,返回该医生当天所有挂号患者的姓名和联系电话 原创精品资源学科网独家享有版权,侵权必究！ 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网(北京)股份有限公司 学科网（北京）股份有限公司 期末复习卷《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_viewing,字段如下: vid(看房编号) char(10) 主键, cid(客户编号) char(10) 非空, hid(房屋编号) char(10) 非空, viewtime(看房时间) datetime, remark(备注) varchar(100) 2).向t_viewing表中插入一条数据:看房编号 v0002,客户编号 c0008,房屋编号 h0010,看房时间 2025-06-15 10:00:00 3).为t_client表添加viplevel字段(会员等级),类型 int,默认0 4).将t_house表中房屋编号 h0012 的联系电话修改为 13912345678 5).查询价格在2000到3500之间且面积大于 70 平方米的所有房屋信息 6).查询客户李华的所有订单,显示客户姓名、房屋地址、租赁时间 7).创建视图v_house_order,显示房屋订单信息:房屋地址、户主电话、客户姓名、租赁时长 答案: 1).CREATE TABLE t_viewing (vid CHAR(10) PRIMARY KEY,cid CHAR(10) NOT NULL, hid CHAR(10) NOT NULL,viewtime DATETIME, remark VARCHAR(100)); 2). INSERT INTO t_viewing (vid, cid, hid, viewtime) VALUES ('v0002', 'c0008', 'h0010', '2025-06-15 10:00:00'); 3).ALTER TABLE t_client ADD viplevel INT DEFAULT 0; 4).UPDATE t_house SET tel = '13912345678' WHERE hid = 'h0012'; 5).SELECT * FROM t_house WHERE price BETWEEN 2000 AND 3500 AND area > 70;-- 6).SELECT c.name, h.address, o.time 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_house_order ASSELECT h.address AS 房屋地址, h.tel AS 户主电话, c.name 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_favorite,字段如下: favid(收藏编号) char(10) 主键, pid(动态编号) char(10) 非空, uid(用户编号) char(10) 非空, favtime(收藏时间) datetime 2).向t_favorite表中插入一条数据:收藏编号 f0003,动态编号 p0010,用户编号 u0020,收藏时间 2025-05-20 12:00:00 3).为t_post表添加likecount字段(点赞数),类型 int,默认 0 4).将t_user表中用户编号 u0015 的年龄修改为 22 5).查询性别为男且年龄大于 20 岁的所有用户信息 6).查询用户王丽的所有好友昵称和添加时间 7).创建视图v_user_post,显示用户动态:昵称、动态内容、发布时间 8).创建触发器:当删除一条动态时,自动删除该动态下的所有点赞记录 9).创建存储过程proc_unfriend,输入两个用户编号,实现双向删除好友 答案: 1).CREATE TABLE t_favorite ( favid CHAR(10) PRIMARY KEY, pid CHAR(10) NOT NULL, uid CHAR(10) NOT NULL, favtime DATETIME); 2).INSERT INTO t_favorite (favid, pid, uid, favtime) VALUES ('f0003', 'p0010', 'u0020', '2025-05-20 12:00:00'); 3).ALTER TABLE t_post ADD likecount INT DEFAULT 0; 4).UPDATE t_user SET age = 22 WHERE uid = 'u0015'; 5).SELECT * FROM t_user WHERE sex = '男' AND age > 20; 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_post ASSELECT u.nickname AS 昵称, p.content AS 动态内容, p.createtime AS 发布时间FROM t_post p JOIN t_user u ON p.uid = u.uid; 8).DELIMITER //CREATE TRIGGER trg_delete_post_likes BEFORE DELETE ON t_post FOR EACH ROWBEGIN DELETE FROM t_likes WHERE pid = OLD.pid;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE proc_unfriend(IN uid1 CHAR(10), IN uid2 CHAR(10))BEGIN DELETE FROM t_friendship WHERE (uid = uid1 AND fid = uid2) OR (uid = uid2 AND fid = uid1);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_review,字段如下: rid(评价编号) char(10) 主键, cid(课程编号) char(10) 非空, sid(学生编号) char(10) 非空, score(评分) int, content(评价内容) text 2).向t_review表中插入一条数据:评价编号r0005,课程编号 c0010,学生编号 s0012,评分 95,内容讲得很好 3).为t_course表添加teacher字段(授课教师),类型varchar(50) 4).将t_video表中课程编号 c0008 的视频链接修改为data:http://www.test.com 5).查询课时大于 40 的所有课程信息 6).查询学生张伟学习的所有课程,显示学生姓名、课程名称、学习进度 7).创建视图v_student_course,显示学生选课情况:学生姓名、班级、课程名称、课时 8).创建触发器:当删除一个课程时,自动删除该课程下的所有视频和学习记录 9).创建存储过程proc_course_student_count,输入课程编号,返回该课程的学生学习人数 答案: 1).CREATE TABLE t_review (rid CHAR(10) PRIMARY KEY, cid CHAR(10) NOT NULL, sid CHAR(10) NOT NULL, score INT, content TEXT); 2).INSERT INTO t_review (rid, cid, sid, score, content) VALUES ('r0005', 'c0010', 's0012', 95, '讲得很好'); 3).ALTER TABLE t_course ADD teacher VARCHAR(50); 4).UPDATE t_video SET link = 'http://www.test.com' WHERE cid = 'c0008';-- 5).SELECT * FROM t_course WHERE classhour > 40; 6).SELECT s.sname, c.cname, l.schedule FROM t_Learn lJOIN t_student s ON l.sid = s.sid JOIN t_course c ON l.cid = c.cid WHERE s.sname = '张伟'; 7).CREATE VIEW v_student_course ASSELECT s.sname AS 学生姓名, s.classes AS 班级,c.cname AS 课程名称, c.classhour AS 课时FROM t_Learn l JOIN t_student s ON l.sid = s.sid JOIN t_course c ON l.cid = c.cid; 8).DELIMITER //CREATE TRIGGER trg_delete_course BEFORE DELETE ON t_course FOR EACH ROWBEGIN DELETE FROM t_video WHERE cid = OLD.cid; DELETE FROM t_Learn WHERE cid = OLD.cid;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE proc_course_student_count(IN course_id CHAR(10), OUT student_count INT) BEGIN SELECT COUNT(DISTINCT sid) INTO student_count FROM t_Learn WHERE cid = course_id;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_exam,字段如下: eid(考试编号) char(10) 主键, sid(学生编号) char(10) 非空, cid(科目编号) char(10) 非空, examscore(考试成绩) decimal(5,2), examdate(考试日期) date 2).向t_exam表中插入一条数据:考试编号 e0010,学生编号 s0030,科目编号 c0020,考试成绩 88.5,考试日期 2025-07-01 3).为t_student表添加enrollment字段(入学年份),类型 year 4).将t_course表中科目编号 c0015 的科目名称修改为高等数学 5).查询总分大于 100 的所有科目信息 6).查询班级为高二1班的学生中英语成绩大于 80 分的学生姓名和英语成绩 7).创建视图v_exam_rank,显示考试排名:学生姓名、科目名称、考试成绩 8).创建触发器:当插入或更新考试成绩时,自动更新该科目的平均分 9).创建存储过程proc_student_rank,输入学生编号,返回该学生在所有科目中的总分排名 答案: 1).CREATE TABLE t_exam (eid CHAR(10) PRIMARY KEY, sid CHAR(10) NOT NULL, cid CHAR(10) NOT NULL,examscore DECIMAL(5,2),examdate DATE); 2).INSERT INTO t_exam (eid, sid, cid, examscore, examdate) VALUES ('e0010', 's0030', 'c0020', 88.5, '2025-07-01'); 3).ALTER TABLE t_student ADD enrollment YEAR; 4).UPDATE t_course SET cname = '高等数学' WHERE cid = 'c0015'; 5).SELECT * FROM t_course WHERE total > 100; 6).SELECT s.sname, g.score FROM t_grade g JOIN t_student s ON g.sid = s.sid JOIN t_course c ON g.cid = c.cid WHERE s.class = '高二1班' AND c.cname = '英语' AND g.score > 80; 7).CREATE VIEW v_exam_rank ASSELECT s.sname AS 学生姓名, c.cname AS 科目名称, e.examscore AS 考试成绩FROM t_exam e JOIN t_student s ON e.sid = s.sid JOIN t_course c ON e.cid = c.cid ORDER BY e.examscore DESC; 8).DELIMITER //CREATE TRIGGER trg_update_course_avg AFTER INSERT ON t_exam FOR EACH ROWBEGIN DECLARE avg_score DECIMAL(5,2);SELECT AVG(examscore) INTO avg_score FROM t_exam WHERE cid = NEW.cid; UPDATE t_course SET avgscore = avg_score WHERE cid = NEW.cid;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE proc_student_rank(IN stu_sid CHAR(10))BEGIN SELECT s.sname, SUM(g.score) AS 总分, RANK() OVER (ORDER BY SUM(g.score) DESC) AS 排名 FROM t_grade g JOIN t_student s ON g.sid = s.sid WHERE g.sid = stu_sid GROUP BY g.sid;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_medicine,字段如下: mid(药品编号) char(10) 主键, mname(药品名称) varchar(50), price(价格) decimal(8,2), stock(库存量) int 2).向t_medicine表中插入一条数据:药品编号 m0010,药品名称布洛芬,价格 25.00,库存 100 3).为t_registration表添加fee字段(挂号费),类型 decimal(6,2),默认 10.00 4).将t_patient表中患者编号 p0020 的联系电话修改为 15987654321 5).查询年龄大于 60 岁的所有患者信息 6).查询医生张三的所有挂号患者,显示患者姓名、挂号日期、医生姓名 7).创建视图v_patient_medical,显示患者病历:患者姓名、医生姓名、诊断结果、就诊时间 8).创建触发器:当插入一条挂号记录时,自动将挂号费累加到该医生当天总收入 9).创建存储过程proc_today_patients,输入医生编号和日期,返回该医生当天所有挂号患者的姓名和联系电话 答案: 1).CREATE TABLE t_medicine (mid CHAR(10) PRIMARY KEY,mname VARCHAR(50), price DECIMAL(8,2), stock INT); 2).INSERT INTO t_medicine (mid, mname, price, stock) VALUES ('m0010', '布洛芬', 25.00, 100); 3).ALTER TABLE t_registration ADD fee DECIMAL(6,2) DEFAULT 10.00; 4).UPDATE t_patient SET tel = '15987654321' WHERE pid = 'p0020'; 5).SELECT * FROM t_patient WHERE age > 60; 6).SELECT p.pname, r.rtime, d.dname FROM t_registration r JOIN t_patient p ON r.pid = p.pid JOIN t_doctor d ON r.did = d.did WHERE d.dname = '张三'; 7).CREATE VIEW v_patient_medical ASSELECT p.pname AS 患者姓名, d.dname AS 医生姓名,m.diagnosis AS 诊断结果, m.medtime AS 就诊时间FROM t_medical m JOIN t_patient p ON m.pid = p.pid JOIN t_doctor d ON m.did = d.did; 8).DELIMITER //CREATE TRIGGER trg_add_daily_income AFTER INSERT ON t_registration FOR EACH ROWBEGIN UPDATE t_doctor SET daily_income = daily_income + NEW.fee WHERE did = NEW.did;END //DELIMITER ; 9).DELIMITER //CREATE PROCEDURE proc_today_patients(IN doctor_id CHAR(10), IN reg_date DATE)BEGIN SELECT p.pname AS 患者姓名, p.tel AS 联系电话 FROM t_registration r JOIN t_patient p ON r.pid = p.pid WHERE r.did = doctor_id AND DATE(r.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; $