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