605 lines
47 KiB
Markdown
605 lines
47 KiB
Markdown
### 表结构
|
||
|
||
```sql
|
||
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : localhost_3306
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50743
|
||
Source Host : localhost:3306
|
||
Source Schema : db_education
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50743
|
||
File Encoding : 65001
|
||
|
||
Date: 27/03/2025 12:56:48
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_course
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_course`;
|
||
CREATE TABLE `t_course` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
||
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`period` int(10) NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10005 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of t_course
|
||
-- ----------------------------
|
||
INSERT INTO `t_course` VALUES (10001, '语文', '高中语文课程', 48);
|
||
INSERT INTO `t_course` VALUES (10002, '数学', '高中数学课程', 48);
|
||
INSERT INTO `t_course` VALUES (10003, '英语', '高中英语课程', 48);
|
||
INSERT INTO `t_course` VALUES (10004, '物理', '高中物理', 24);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_learn
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_learn`;
|
||
CREATE TABLE `t_learn` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`s_id` int(10) NOT NULL,
|
||
`c_id` int(10) NOT NULL,
|
||
`schedule` int(11) NULL DEFAULT 0,
|
||
`createtime` datetime NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10201 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of t_learn
|
||
-- ----------------------------
|
||
INSERT INTO `t_learn` VALUES (10001, 10025, 10001, 17, '2024-05-17 11:38:34');
|
||
INSERT INTO `t_learn` VALUES (10002, 10032, 10001, 36, '2024-01-30 10:55:51');
|
||
INSERT INTO `t_learn` VALUES (10003, 10072, 10001, 44, '2024-09-12 09:41:22');
|
||
INSERT INTO `t_learn` VALUES (10004, 10010, 10001, 8, '2023-03-23 03:19:04');
|
||
INSERT INTO `t_learn` VALUES (10005, 10045, 10001, 46, '2023-08-03 01:06:54');
|
||
INSERT INTO `t_learn` VALUES (10006, 10086, 10001, 42, '2023-11-23 08:05:33');
|
||
INSERT INTO `t_learn` VALUES (10007, 10050, 10001, 3, '2024-10-27 22:15:01');
|
||
INSERT INTO `t_learn` VALUES (10008, 10046, 10001, 13, '2024-04-03 07:26:53');
|
||
INSERT INTO `t_learn` VALUES (10009, 10011, 10001, 31, '2023-09-28 20:42:04');
|
||
INSERT INTO `t_learn` VALUES (10010, 10055, 10001, 20, '2024-02-03 04:12:27');
|
||
INSERT INTO `t_learn` VALUES (10011, 10044, 10001, 15, '2023-10-05 10:23:35');
|
||
INSERT INTO `t_learn` VALUES (10013, 10040, 10001, 25, '2024-03-04 10:10:18');
|
||
INSERT INTO `t_learn` VALUES (10014, 10074, 10001, 14, '2024-03-12 11:24:43');
|
||
INSERT INTO `t_learn` VALUES (10015, 10069, 10001, 11, '2023-01-28 02:34:49');
|
||
INSERT INTO `t_learn` VALUES (10016, 10067, 10001, 11, '2024-04-29 22:19:43');
|
||
INSERT INTO `t_learn` VALUES (10017, 10087, 10001, 15, '2023-08-29 06:34:45');
|
||
INSERT INTO `t_learn` VALUES (10018, 10080, 10001, 24, '2024-11-11 00:58:52');
|
||
INSERT INTO `t_learn` VALUES (10019, 10093, 10001, 43, '2023-05-12 18:41:48');
|
||
INSERT INTO `t_learn` VALUES (10020, 10028, 10001, 35, '2023-05-17 17:04:32');
|
||
INSERT INTO `t_learn` VALUES (10021, 10062, 10001, 11, '2023-01-29 18:14:58');
|
||
INSERT INTO `t_learn` VALUES (10022, 10049, 10001, 34, '2024-09-25 10:38:12');
|
||
INSERT INTO `t_learn` VALUES (10023, 10039, 10001, 22, '2024-02-15 18:52:15');
|
||
INSERT INTO `t_learn` VALUES (10024, 10005, 10001, 29, '2023-04-25 08:55:57');
|
||
INSERT INTO `t_learn` VALUES (10025, 10065, 10001, 20, '2024-10-30 11:22:37');
|
||
INSERT INTO `t_learn` VALUES (10026, 10047, 10001, 22, '2023-09-07 21:46:19');
|
||
INSERT INTO `t_learn` VALUES (10027, 10012, 10001, 10, '2023-10-10 23:42:06');
|
||
INSERT INTO `t_learn` VALUES (10028, 10037, 10001, 5, '2024-03-09 23:35:22');
|
||
INSERT INTO `t_learn` VALUES (10029, 10018, 10001, 1, '2024-11-24 06:32:13');
|
||
INSERT INTO `t_learn` VALUES (10030, 10066, 10001, 27, '2023-12-01 18:53:00');
|
||
INSERT INTO `t_learn` VALUES (10031, 10063, 10001, 28, '2023-06-25 02:55:53');
|
||
INSERT INTO `t_learn` VALUES (10032, 10090, 10001, 47, '2024-04-21 14:00:37');
|
||
INSERT INTO `t_learn` VALUES (10033, 10085, 10001, 33, '2023-03-22 05:46:52');
|
||
INSERT INTO `t_learn` VALUES (10034, 10092, 10001, 5, '2024-04-13 02:36:54');
|
||
INSERT INTO `t_learn` VALUES (10035, 10060, 10001, 12, '2023-01-16 11:50:07');
|
||
INSERT INTO `t_learn` VALUES (10036, 10088, 10001, 7, '2023-10-17 01:08:32');
|
||
INSERT INTO `t_learn` VALUES (10037, 10071, 10001, 36, '2023-10-10 22:28:02');
|
||
INSERT INTO `t_learn` VALUES (10038, 10079, 10001, 33, '2024-08-31 07:01:33');
|
||
INSERT INTO `t_learn` VALUES (10039, 10091, 10001, 6, '2024-12-08 01:13:17');
|
||
INSERT INTO `t_learn` VALUES (10040, 10003, 10001, 2, '2023-02-18 11:46:20');
|
||
INSERT INTO `t_learn` VALUES (10041, 10083, 10001, 26, '2023-06-28 14:08:02');
|
||
INSERT INTO `t_learn` VALUES (10042, 10054, 10001, 43, '2023-09-14 12:57:41');
|
||
INSERT INTO `t_learn` VALUES (10043, 10017, 10001, 27, '2024-04-29 04:22:03');
|
||
INSERT INTO `t_learn` VALUES (10044, 10021, 10001, 43, '2023-09-11 09:03:59');
|
||
INSERT INTO `t_learn` VALUES (10045, 10014, 10001, 31, '2024-06-28 11:20:58');
|
||
INSERT INTO `t_learn` VALUES (10046, 10051, 10001, 24, '2023-06-19 05:29:25');
|
||
INSERT INTO `t_learn` VALUES (10047, 10035, 10001, 17, '2024-02-06 00:48:21');
|
||
INSERT INTO `t_learn` VALUES (10048, 10008, 10001, 29, '2023-12-28 10:32:43');
|
||
INSERT INTO `t_learn` VALUES (10049, 10100, 10001, 19, '2023-07-23 18:51:30');
|
||
INSERT INTO `t_learn` VALUES (10050, 10016, 10001, 33, '2024-07-05 11:07:38');
|
||
INSERT INTO `t_learn` VALUES (10051, 10033, 10001, 9, '2024-06-27 11:06:15');
|
||
INSERT INTO `t_learn` VALUES (10052, 10022, 10001, 15, '2023-11-29 06:00:37');
|
||
INSERT INTO `t_learn` VALUES (10053, 10082, 10001, 41, '2024-05-10 13:59:37');
|
||
INSERT INTO `t_learn` VALUES (10054, 10096, 10001, 11, '2023-02-27 13:35:38');
|
||
INSERT INTO `t_learn` VALUES (10055, 10030, 10001, 27, '2023-01-08 00:29:21');
|
||
INSERT INTO `t_learn` VALUES (10056, 10029, 10001, 24, '2024-03-01 05:48:04');
|
||
INSERT INTO `t_learn` VALUES (10057, 10075, 10001, 21, '2024-11-09 23:10:32');
|
||
INSERT INTO `t_learn` VALUES (10058, 10053, 10001, 1, '2024-10-28 14:38:52');
|
||
INSERT INTO `t_learn` VALUES (10059, 10041, 10001, 21, '2024-11-04 06:31:31');
|
||
INSERT INTO `t_learn` VALUES (10060, 10027, 10001, 14, '2024-08-30 16:31:07');
|
||
INSERT INTO `t_learn` VALUES (10061, 10031, 10001, 30, '2023-05-27 05:01:32');
|
||
INSERT INTO `t_learn` VALUES (10062, 10052, 10001, 17, '2024-10-28 01:47:09');
|
||
INSERT INTO `t_learn` VALUES (10063, 10026, 10001, 30, '2023-07-09 12:57:40');
|
||
INSERT INTO `t_learn` VALUES (10064, 10089, 10001, 15, '2023-10-01 05:36:14');
|
||
INSERT INTO `t_learn` VALUES (10065, 10043, 10001, 42, '2024-12-09 18:42:26');
|
||
INSERT INTO `t_learn` VALUES (10066, 10070, 10001, 11, '2023-02-18 10:25:15');
|
||
INSERT INTO `t_learn` VALUES (10067, 10059, 10001, 11, '2024-03-30 03:20:04');
|
||
INSERT INTO `t_learn` VALUES (10068, 10001, 10001, 6, '2024-05-16 09:40:05');
|
||
INSERT INTO `t_learn` VALUES (10069, 10023, 10001, 44, '2024-04-21 10:45:41');
|
||
INSERT INTO `t_learn` VALUES (10070, 10004, 10001, 3, '2024-08-13 07:19:31');
|
||
INSERT INTO `t_learn` VALUES (10071, 10076, 10001, 39, '2024-10-25 10:09:28');
|
||
INSERT INTO `t_learn` VALUES (10072, 10056, 10001, 37, '2023-09-01 08:05:29');
|
||
INSERT INTO `t_learn` VALUES (10073, 10019, 10001, 40, '2024-06-21 07:31:46');
|
||
INSERT INTO `t_learn` VALUES (10074, 10002, 10001, 38, '2023-03-14 18:31:13');
|
||
INSERT INTO `t_learn` VALUES (10075, 10064, 10001, 23, '2024-04-01 22:39:29');
|
||
INSERT INTO `t_learn` VALUES (10076, 10036, 10001, 44, '2023-08-09 04:24:49');
|
||
INSERT INTO `t_learn` VALUES (10077, 10078, 10001, 40, '2024-10-08 05:24:30');
|
||
INSERT INTO `t_learn` VALUES (10078, 10081, 10001, 21, '2024-04-09 13:56:25');
|
||
INSERT INTO `t_learn` VALUES (10079, 10084, 10001, 39, '2023-08-29 11:57:20');
|
||
INSERT INTO `t_learn` VALUES (10080, 10038, 10001, 15, '2024-10-02 13:21:22');
|
||
INSERT INTO `t_learn` VALUES (10081, 10025, 10002, 17, '2024-05-17 11:38:34');
|
||
INSERT INTO `t_learn` VALUES (10082, 10032, 10002, 36, '2024-01-30 10:55:51');
|
||
INSERT INTO `t_learn` VALUES (10083, 10072, 10002, 44, '2024-09-12 09:41:22');
|
||
INSERT INTO `t_learn` VALUES (10084, 10010, 10002, 8, '2023-03-23 03:19:04');
|
||
INSERT INTO `t_learn` VALUES (10085, 10045, 10002, 46, '2023-08-03 01:06:54');
|
||
INSERT INTO `t_learn` VALUES (10086, 10086, 10002, 42, '2023-11-23 08:05:33');
|
||
INSERT INTO `t_learn` VALUES (10087, 10050, 10002, 3, '2024-10-27 22:15:01');
|
||
INSERT INTO `t_learn` VALUES (10088, 10046, 10002, 13, '2024-04-03 07:26:53');
|
||
INSERT INTO `t_learn` VALUES (10089, 10011, 10002, 31, '2023-09-28 20:42:04');
|
||
INSERT INTO `t_learn` VALUES (10090, 10055, 10002, 20, '2024-02-03 04:12:27');
|
||
INSERT INTO `t_learn` VALUES (10091, 10044, 10002, 15, '2023-10-05 10:23:35');
|
||
INSERT INTO `t_learn` VALUES (10092, 10098, 10002, 35, '2023-05-19 22:15:18');
|
||
INSERT INTO `t_learn` VALUES (10093, 10040, 10002, 25, '2024-03-04 10:10:18');
|
||
INSERT INTO `t_learn` VALUES (10094, 10074, 10002, 14, '2024-03-12 11:24:43');
|
||
INSERT INTO `t_learn` VALUES (10095, 10069, 10002, 11, '2023-01-28 02:34:49');
|
||
INSERT INTO `t_learn` VALUES (10096, 10067, 10002, 11, '2024-04-29 22:19:43');
|
||
INSERT INTO `t_learn` VALUES (10097, 10087, 10002, 15, '2023-08-29 06:34:45');
|
||
INSERT INTO `t_learn` VALUES (10098, 10080, 10002, 24, '2024-11-11 00:58:52');
|
||
INSERT INTO `t_learn` VALUES (10099, 10093, 10002, 43, '2023-05-12 18:41:48');
|
||
INSERT INTO `t_learn` VALUES (10100, 10028, 10002, 35, '2023-05-17 17:04:32');
|
||
INSERT INTO `t_learn` VALUES (10101, 10062, 10002, 11, '2023-01-29 18:14:58');
|
||
INSERT INTO `t_learn` VALUES (10102, 10049, 10002, 34, '2024-09-25 10:38:12');
|
||
INSERT INTO `t_learn` VALUES (10103, 10039, 10002, 22, '2024-02-15 18:52:15');
|
||
INSERT INTO `t_learn` VALUES (10104, 10005, 10002, 29, '2023-04-25 08:55:57');
|
||
INSERT INTO `t_learn` VALUES (10105, 10065, 10002, 20, '2024-10-30 11:22:37');
|
||
INSERT INTO `t_learn` VALUES (10106, 10047, 10002, 22, '2023-09-07 21:46:19');
|
||
INSERT INTO `t_learn` VALUES (10107, 10012, 10002, 10, '2023-10-10 23:42:06');
|
||
INSERT INTO `t_learn` VALUES (10108, 10037, 10002, 5, '2024-03-09 23:35:22');
|
||
INSERT INTO `t_learn` VALUES (10109, 10018, 10002, 1, '2024-11-24 06:32:13');
|
||
INSERT INTO `t_learn` VALUES (10110, 10066, 10002, 27, '2023-12-01 18:53:00');
|
||
INSERT INTO `t_learn` VALUES (10111, 10063, 10002, 28, '2023-06-25 02:55:53');
|
||
INSERT INTO `t_learn` VALUES (10112, 10090, 10002, 47, '2024-04-21 14:00:37');
|
||
INSERT INTO `t_learn` VALUES (10113, 10085, 10002, 33, '2023-03-22 05:46:52');
|
||
INSERT INTO `t_learn` VALUES (10114, 10092, 10002, 5, '2024-04-13 02:36:54');
|
||
INSERT INTO `t_learn` VALUES (10115, 10060, 10002, 12, '2023-01-16 11:50:07');
|
||
INSERT INTO `t_learn` VALUES (10116, 10088, 10002, 7, '2023-10-17 01:08:32');
|
||
INSERT INTO `t_learn` VALUES (10117, 10071, 10002, 36, '2023-10-10 22:28:02');
|
||
INSERT INTO `t_learn` VALUES (10118, 10079, 10002, 33, '2024-08-31 07:01:33');
|
||
INSERT INTO `t_learn` VALUES (10119, 10091, 10002, 6, '2024-12-08 01:13:17');
|
||
INSERT INTO `t_learn` VALUES (10120, 10003, 10002, 2, '2023-02-18 11:46:20');
|
||
INSERT INTO `t_learn` VALUES (10121, 10083, 10002, 26, '2023-06-28 14:08:02');
|
||
INSERT INTO `t_learn` VALUES (10122, 10054, 10002, 43, '2023-09-14 12:57:41');
|
||
INSERT INTO `t_learn` VALUES (10123, 10017, 10002, 27, '2024-04-29 04:22:03');
|
||
INSERT INTO `t_learn` VALUES (10124, 10021, 10002, 43, '2023-09-11 09:03:59');
|
||
INSERT INTO `t_learn` VALUES (10125, 10014, 10002, 31, '2024-06-28 11:20:58');
|
||
INSERT INTO `t_learn` VALUES (10126, 10051, 10002, 24, '2023-06-19 05:29:25');
|
||
INSERT INTO `t_learn` VALUES (10127, 10035, 10002, 17, '2024-02-06 00:48:21');
|
||
INSERT INTO `t_learn` VALUES (10128, 10008, 10002, 29, '2023-12-28 10:32:43');
|
||
INSERT INTO `t_learn` VALUES (10129, 10100, 10002, 19, '2023-07-23 18:51:30');
|
||
INSERT INTO `t_learn` VALUES (10130, 10016, 10002, 33, '2024-07-05 11:07:38');
|
||
INSERT INTO `t_learn` VALUES (10131, 10033, 10002, 9, '2024-06-27 11:06:15');
|
||
INSERT INTO `t_learn` VALUES (10132, 10022, 10002, 15, '2023-11-29 06:00:37');
|
||
INSERT INTO `t_learn` VALUES (10133, 10082, 10002, 41, '2024-05-10 13:59:37');
|
||
INSERT INTO `t_learn` VALUES (10134, 10096, 10002, 11, '2023-02-27 13:35:38');
|
||
INSERT INTO `t_learn` VALUES (10135, 10030, 10002, 27, '2023-01-08 00:29:21');
|
||
INSERT INTO `t_learn` VALUES (10136, 10029, 10002, 24, '2024-03-01 05:48:04');
|
||
INSERT INTO `t_learn` VALUES (10137, 10075, 10002, 21, '2024-11-09 23:10:32');
|
||
INSERT INTO `t_learn` VALUES (10138, 10053, 10002, 1, '2024-10-28 14:38:52');
|
||
INSERT INTO `t_learn` VALUES (10139, 10041, 10002, 21, '2024-11-04 06:31:31');
|
||
INSERT INTO `t_learn` VALUES (10140, 10027, 10002, 14, '2024-08-30 16:31:07');
|
||
INSERT INTO `t_learn` VALUES (10141, 10031, 10002, 30, '2023-05-27 05:01:32');
|
||
INSERT INTO `t_learn` VALUES (10142, 10052, 10002, 17, '2024-10-28 01:47:09');
|
||
INSERT INTO `t_learn` VALUES (10143, 10026, 10002, 30, '2023-07-09 12:57:40');
|
||
INSERT INTO `t_learn` VALUES (10144, 10089, 10002, 15, '2023-10-01 05:36:14');
|
||
INSERT INTO `t_learn` VALUES (10145, 10043, 10002, 42, '2024-12-09 18:42:26');
|
||
INSERT INTO `t_learn` VALUES (10146, 10070, 10002, 11, '2023-02-18 10:25:15');
|
||
INSERT INTO `t_learn` VALUES (10147, 10059, 10002, 11, '2024-03-30 03:20:04');
|
||
INSERT INTO `t_learn` VALUES (10148, 10001, 10002, 6, '2024-05-16 09:40:05');
|
||
INSERT INTO `t_learn` VALUES (10149, 10023, 10002, 44, '2024-04-21 10:45:41');
|
||
INSERT INTO `t_learn` VALUES (10150, 10004, 10002, 3, '2024-08-13 07:19:31');
|
||
INSERT INTO `t_learn` VALUES (10151, 10025, 10003, 17, '2024-05-17 11:38:34');
|
||
INSERT INTO `t_learn` VALUES (10152, 10032, 10003, 36, '2024-01-30 10:55:51');
|
||
INSERT INTO `t_learn` VALUES (10153, 10072, 10003, 44, '2024-09-12 09:41:22');
|
||
INSERT INTO `t_learn` VALUES (10154, 10010, 10003, 8, '2023-03-23 03:19:04');
|
||
INSERT INTO `t_learn` VALUES (10155, 10045, 10003, 46, '2023-08-03 01:06:54');
|
||
INSERT INTO `t_learn` VALUES (10156, 10086, 10003, 42, '2023-11-23 08:05:33');
|
||
INSERT INTO `t_learn` VALUES (10157, 10050, 10003, 3, '2024-10-27 22:15:01');
|
||
INSERT INTO `t_learn` VALUES (10158, 10046, 10003, 13, '2024-04-03 07:26:53');
|
||
INSERT INTO `t_learn` VALUES (10159, 10011, 10003, 31, '2023-09-28 20:42:04');
|
||
INSERT INTO `t_learn` VALUES (10160, 10055, 10003, 20, '2024-02-03 04:12:27');
|
||
INSERT INTO `t_learn` VALUES (10161, 10044, 10003, 15, '2023-10-05 10:23:35');
|
||
INSERT INTO `t_learn` VALUES (10162, 10098, 10003, 35, '2023-05-19 22:15:18');
|
||
INSERT INTO `t_learn` VALUES (10163, 10040, 10003, 25, '2024-03-04 10:10:18');
|
||
INSERT INTO `t_learn` VALUES (10164, 10074, 10003, 14, '2024-03-12 11:24:43');
|
||
INSERT INTO `t_learn` VALUES (10165, 10069, 10003, 11, '2023-01-28 02:34:49');
|
||
INSERT INTO `t_learn` VALUES (10166, 10067, 10003, 11, '2024-04-29 22:19:43');
|
||
INSERT INTO `t_learn` VALUES (10167, 10087, 10003, 15, '2023-08-29 06:34:45');
|
||
INSERT INTO `t_learn` VALUES (10168, 10080, 10003, 24, '2024-11-11 00:58:52');
|
||
INSERT INTO `t_learn` VALUES (10169, 10093, 10003, 43, '2023-05-12 18:41:48');
|
||
INSERT INTO `t_learn` VALUES (10170, 10028, 10003, 35, '2023-05-17 17:04:32');
|
||
INSERT INTO `t_learn` VALUES (10171, 10062, 10003, 11, '2023-01-29 18:14:58');
|
||
INSERT INTO `t_learn` VALUES (10172, 10049, 10003, 34, '2024-09-25 10:38:12');
|
||
INSERT INTO `t_learn` VALUES (10173, 10039, 10003, 22, '2024-02-15 18:52:15');
|
||
INSERT INTO `t_learn` VALUES (10174, 10005, 10003, 29, '2023-04-25 08:55:57');
|
||
INSERT INTO `t_learn` VALUES (10175, 10065, 10003, 20, '2024-10-30 11:22:37');
|
||
INSERT INTO `t_learn` VALUES (10176, 10047, 10003, 22, '2023-09-07 21:46:19');
|
||
INSERT INTO `t_learn` VALUES (10177, 10012, 10003, 10, '2023-10-10 23:42:06');
|
||
INSERT INTO `t_learn` VALUES (10178, 10037, 10003, 5, '2024-03-09 23:35:22');
|
||
INSERT INTO `t_learn` VALUES (10179, 10018, 10003, 1, '2024-11-24 06:32:13');
|
||
INSERT INTO `t_learn` VALUES (10180, 10066, 10003, 27, '2023-12-01 18:53:00');
|
||
INSERT INTO `t_learn` VALUES (10181, 10063, 10003, 28, '2023-06-25 02:55:53');
|
||
INSERT INTO `t_learn` VALUES (10182, 10090, 10003, 47, '2024-04-21 14:00:37');
|
||
INSERT INTO `t_learn` VALUES (10183, 10085, 10003, 33, '2023-03-22 05:46:52');
|
||
INSERT INTO `t_learn` VALUES (10184, 10092, 10003, 5, '2024-04-13 02:36:54');
|
||
INSERT INTO `t_learn` VALUES (10185, 10060, 10003, 12, '2023-01-16 11:50:07');
|
||
INSERT INTO `t_learn` VALUES (10186, 10088, 10003, 7, '2023-10-17 01:08:32');
|
||
INSERT INTO `t_learn` VALUES (10187, 10071, 10003, 36, '2023-10-10 22:28:02');
|
||
INSERT INTO `t_learn` VALUES (10188, 10079, 10003, 33, '2024-08-31 07:01:33');
|
||
INSERT INTO `t_learn` VALUES (10189, 10091, 10003, 6, '2024-12-08 01:13:17');
|
||
INSERT INTO `t_learn` VALUES (10190, 10003, 10003, 2, '2023-02-18 11:46:20');
|
||
INSERT INTO `t_learn` VALUES (10191, 10083, 10003, 26, '2023-06-28 14:08:02');
|
||
INSERT INTO `t_learn` VALUES (10192, 10054, 10003, 43, '2023-09-14 12:57:41');
|
||
INSERT INTO `t_learn` VALUES (10193, 10017, 10003, 27, '2024-04-29 04:22:03');
|
||
INSERT INTO `t_learn` VALUES (10194, 10021, 10003, 43, '2023-09-11 09:03:59');
|
||
INSERT INTO `t_learn` VALUES (10195, 10014, 10003, 31, '2024-06-28 11:20:58');
|
||
INSERT INTO `t_learn` VALUES (10196, 10051, 10003, 24, '2023-06-19 05:29:25');
|
||
INSERT INTO `t_learn` VALUES (10197, 10035, 10003, 17, '2024-02-06 00:48:21');
|
||
INSERT INTO `t_learn` VALUES (10198, 10008, 10003, 29, '2023-12-28 10:32:43');
|
||
INSERT INTO `t_learn` VALUES (10199, 10100, 10003, 19, '2023-07-23 18:51:30');
|
||
INSERT INTO `t_learn` VALUES (10200, 10016, 10003, 33, '2024-07-05 11:07:38');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_student
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_student`;
|
||
CREATE TABLE `t_student` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
||
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10101 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of t_student
|
||
-- ----------------------------
|
||
INSERT INTO `t_student` VALUES (10001, '周岚', 'G1WGE2rmBJ', 'BnxWZAnSPk');
|
||
INSERT INTO `t_student` VALUES (10002, '石晓明', 'O5UrHL3wAk', 'jXvPgYp6T7');
|
||
INSERT INTO `t_student` VALUES (10003, '丁子韬', 'z6scv3YR39', 'Gkj7yea68K');
|
||
INSERT INTO `t_student` VALUES (10004, '贾詩涵', 'dDRhbsIFld', '9S5wmKyd8u');
|
||
INSERT INTO `t_student` VALUES (10005, '贾震南', 'yp6ONN6mPK', 'rESuH77r0D');
|
||
INSERT INTO `t_student` VALUES (10006, '龚杰宏', '6mX9UUocUJ', 'Vbu9vJS9Eo');
|
||
INSERT INTO `t_student` VALUES (10007, '金詩涵', 'J7CEMWLje5', '7XYgyIh7xR');
|
||
INSERT INTO `t_student` VALUES (10008, '秦子异', 'szo1eVBizJ', 'dY2RfyIb1m');
|
||
INSERT INTO `t_student` VALUES (10009, '袁宇宁', 'J5YrjzB2si', 'UAMXTO3rQ6');
|
||
INSERT INTO `t_student` VALUES (10010, '姜秀英', '2MU2HeylW4', '1AfW3NhbgN');
|
||
INSERT INTO `t_student` VALUES (10011, '汤杰宏', 'MpE4EPWxqG', 'oaNVhDmy7z');
|
||
INSERT INTO `t_student` VALUES (10012, '韦安琪', 'Kdmd781EtP', 'KfjEMQxKep');
|
||
INSERT INTO `t_student` VALUES (10013, '唐嘉伦', 'V0C7xf6fjc', 'e1r7KJIx8w');
|
||
INSERT INTO `t_student` VALUES (10014, '韩詩涵', 'J273ldcncO', '8hcoDqM4G5');
|
||
INSERT INTO `t_student` VALUES (10015, '邱睿', '5f2pShjufE', 'ABRfNTK0oD');
|
||
INSERT INTO `t_student` VALUES (10016, '田云熙', 'r6GS6H1Y9i', 'QLPFuc1Ymo');
|
||
INSERT INTO `t_student` VALUES (10017, '任璐', 'fOEFM89DMY', 'fgm3mOBTRs');
|
||
INSERT INTO `t_student` VALUES (10018, '阎嘉伦', 'uf0T82j8vV', 'MVun8E08gr');
|
||
INSERT INTO `t_student` VALUES (10019, '杨秀英', '3ZQyavexff', 'tne8w9hwyT');
|
||
INSERT INTO `t_student` VALUES (10020, '贺岚', 'MUzeIJ2Zho', '3hTbEiOlcV');
|
||
INSERT INTO `t_student` VALUES (10021, '贾安琪', 'hQKvLXLbdr', 'GxmMRZIVTq');
|
||
INSERT INTO `t_student` VALUES (10022, '李震南', 'umEYhDRNCg', 'VIttqgl4h2');
|
||
INSERT INTO `t_student` VALUES (10023, '张璐', 'MLmnE9XMrj', 'Vo0HRIunBH');
|
||
INSERT INTO `t_student` VALUES (10024, '韦震南', 'g9pxVI84lQ', 'J59D4b8VVF');
|
||
INSERT INTO `t_student` VALUES (10025, '严睿', 'GxDaQjWmSb', 'liZCUpGHfa');
|
||
INSERT INTO `t_student` VALUES (10026, '姜杰宏', 'kygY1DCCEp', 'VEGVJlU6Ra');
|
||
INSERT INTO `t_student` VALUES (10027, '尹震南', 'gDvPS0b24b', 'rjzJgMQWTc');
|
||
INSERT INTO `t_student` VALUES (10028, '罗璐', 'S0jjEsFNQJ', 'C6stBhYttY');
|
||
INSERT INTO `t_student` VALUES (10029, '姚云熙', 'vEr1jpIgKr', 'cyuhQPR8Lh');
|
||
INSERT INTO `t_student` VALUES (10030, '黄子异', 'GRCYTc1DWx', 'kTTYbTor84');
|
||
INSERT INTO `t_student` VALUES (10031, '何詩涵', 'gk2SUc1U35', 'ZRIAUeMSYs');
|
||
INSERT INTO `t_student` VALUES (10032, '宋安琪', '35U0zOXWcV', 'Ab3HmKqiqv');
|
||
INSERT INTO `t_student` VALUES (10033, '陶璐', 'BDNIQACb7W', 'qJD4q0lDsh');
|
||
INSERT INTO `t_student` VALUES (10034, '顾睿', 'BdjipSZSh3', 'mtRT0VxhFe');
|
||
INSERT INTO `t_student` VALUES (10035, '高杰宏', '4IhblDisF7', 'LKKHmwgBXD');
|
||
INSERT INTO `t_student` VALUES (10036, '薛詩涵', 'Y8EEoaicyB', 'rCRrqBFJsv');
|
||
INSERT INTO `t_student` VALUES (10037, '丁秀英', '9SlsI0PoyD', 'qsxw3ign25');
|
||
INSERT INTO `t_student` VALUES (10038, '贾晓明', 'odNONklQs9', 'BiO5UOkdnW');
|
||
INSERT INTO `t_student` VALUES (10039, '任嘉伦', 'VHuzfHBoBO', 'lTAovUC389');
|
||
INSERT INTO `t_student` VALUES (10040, '胡震南', 'sv46bTnf0P', 'iBzeHjykYx');
|
||
INSERT INTO `t_student` VALUES (10041, '萧睿', '0TDvbKZIoK', 'zZ9ZYbUS8y');
|
||
INSERT INTO `t_student` VALUES (10042, '于子韬', 'ByZpvehylm', 'tFjQxRfu6v');
|
||
INSERT INTO `t_student` VALUES (10043, '吴子韬', 'zgNIgSi0R6', 'NnCXSPGSG9');
|
||
INSERT INTO `t_student` VALUES (10044, '袁子异', 'QofuPCZDj2', 'OQKCjRA6KL');
|
||
INSERT INTO `t_student` VALUES (10045, '孙岚', 'RX9ReXfnDD', 'iaFxFUs3UR');
|
||
INSERT INTO `t_student` VALUES (10046, '袁晓明', '9AnMs8NLT7', 'TBAHhl6HP4');
|
||
INSERT INTO `t_student` VALUES (10047, '邹云熙', 'cVTK8Zk23n', 'sHZWvI31eg');
|
||
INSERT INTO `t_student` VALUES (10048, '潘震南', 'sl9DcFJ7l0', 'mCKMLEAWnL');
|
||
INSERT INTO `t_student` VALUES (10049, '侯安琪', 'y0yHJRlVD0', '8w14vG11Lo');
|
||
INSERT INTO `t_student` VALUES (10050, '宋致远', 'mbj6fi5LVJ', 'EvI1OF2mUU');
|
||
INSERT INTO `t_student` VALUES (10051, '向杰宏', 'rdTBGDlk1e', 'KLrEH5OIRV');
|
||
INSERT INTO `t_student` VALUES (10052, '侯岚', 'vRIL8GezRB', 'BCnlCfMe3i');
|
||
INSERT INTO `t_student` VALUES (10053, '郝震南', 'N5OHE7WNRd', 'YSEMSIBoF6');
|
||
INSERT INTO `t_student` VALUES (10054, '田晓明', 'JFjgjbtPYw', 'C1GMv8jJI4');
|
||
INSERT INTO `t_student` VALUES (10055, '金岚', 'gpRnYYtKUp', 'I7Ha61aFlW');
|
||
INSERT INTO `t_student` VALUES (10056, '何晓明', 'mIUWaHvpVT', '0sGahlQonR');
|
||
INSERT INTO `t_student` VALUES (10057, '吕睿', 'FfkVgyM5SS', 'ie36JBbaUq');
|
||
INSERT INTO `t_student` VALUES (10058, '段岚', 'qZWlkeuZou', 'UxP4bndlVw');
|
||
INSERT INTO `t_student` VALUES (10059, '宋詩涵', 'McHsYoxoix', 'QedjPd3cfE');
|
||
INSERT INTO `t_student` VALUES (10060, '谢秀英', 'Pw2td9ptEO', 'YCdTBkV5u1');
|
||
INSERT INTO `t_student` VALUES (10061, '姚睿', 't4zYkGf3fF', '848evloRxx');
|
||
INSERT INTO `t_student` VALUES (10062, '贺安琪', '1RjkUEhkZY', '4f0WkjDBkk');
|
||
INSERT INTO `t_student` VALUES (10063, '段嘉伦', 'qPY9LKYuqQ', 'jeBmxO9JHj');
|
||
INSERT INTO `t_student` VALUES (10064, '唐震南', 'r6bXO95F2D', 'X3HbgEcK8Y');
|
||
INSERT INTO `t_student` VALUES (10065, '谢岚', 'naL2KZrHwA', 'AkqosUcsuV');
|
||
INSERT INTO `t_student` VALUES (10066, '杨安琪', 'AX8Deo1g7Q', 'qaF4nJ5WpP');
|
||
INSERT INTO `t_student` VALUES (10067, '吴杰宏', 'GMzkfndLZv', 'tVfNr43Awi');
|
||
INSERT INTO `t_student` VALUES (10068, '曹晓明', '3MhPP9Ba2T', 'WdLUDxvV4D');
|
||
INSERT INTO `t_student` VALUES (10069, '赵杰宏', 'bifOEeXCWu', 'LOYM3jaDT2');
|
||
INSERT INTO `t_student` VALUES (10070, '钟安琪', 'RaRkUvlMKo', 'YZvGiLMMPa');
|
||
INSERT INTO `t_student` VALUES (10071, '向云熙', 'JLLo5dbzOE', 'dwjwJlsE2J');
|
||
INSERT INTO `t_student` VALUES (10072, '雷晓明', 'SzkAnohkjE', 'vEI4b77pR7');
|
||
INSERT INTO `t_student` VALUES (10073, '汪云熙', 'Dx0e0UItxA', 'phZtzNxzOq');
|
||
INSERT INTO `t_student` VALUES (10074, '杨子异', 'fD9kEW1Sq6', 'zImkNQBSUQ');
|
||
INSERT INTO `t_student` VALUES (10075, '郭睿', 'JnzPqdQDt8', 'gEcH8ew4sF');
|
||
INSERT INTO `t_student` VALUES (10076, '沈子韬', 'ttt1sSrCzJ', '5ywB4pgDqm');
|
||
INSERT INTO `t_student` VALUES (10077, '朱子异', 'XnNaK6Q9gu', '888888');
|
||
INSERT INTO `t_student` VALUES (10078, '侯璐', 'FqbUPAxjR1', 'hTWsxzLogn');
|
||
INSERT INTO `t_student` VALUES (10079, '许宇宁', 'LkzJ9oO3PV', 'sQ12axSWyz');
|
||
INSERT INTO `t_student` VALUES (10080, '高云熙', '89PlIz8Y7B', 'h8VtFDBIgf');
|
||
INSERT INTO `t_student` VALUES (10081, '杜安琪', 'EIeSoLwSW3', 'dla1wIhe3w');
|
||
INSERT INTO `t_student` VALUES (10082, '冯嘉伦', 'Ot9OQzc5Tf', 'HpucsNAfnU');
|
||
INSERT INTO `t_student` VALUES (10083, '彭子韬', 'UkeqT8NtJX', '3fPftOFs96');
|
||
INSERT INTO `t_student` VALUES (10084, '史震南', 'C1ONnCOf1a', '2wTfHZYsnV');
|
||
INSERT INTO `t_student` VALUES (10085, '尹云熙', 'pPD5hlAxiW', 'R9yAP19RJH');
|
||
INSERT INTO `t_student` VALUES (10086, '许震南', 'tHPwJY3CDY', 'kwd4uH98o3');
|
||
INSERT INTO `t_student` VALUES (10087, '李安琪', 'K2r0WllYzO', 'kNRVRYv0qr');
|
||
INSERT INTO `t_student` VALUES (10088, '林子异', '8Ttbp7gc06', 'lj7SdtOYwS');
|
||
INSERT INTO `t_student` VALUES (10089, '严嘉伦', 'PNIs8LHIUr', '7XVizBwqrW');
|
||
INSERT INTO `t_student` VALUES (10090, '黎杰宏', 'rmjckwsCP6', 'O7BYlHG8A5');
|
||
INSERT INTO `t_student` VALUES (10091, '梁杰宏', 'ya3q3e30R9', 'ZpToh85AMq');
|
||
INSERT INTO `t_student` VALUES (10092, '张晓明', 'mkY7T8tpA6', 'PW3j7y3ZQS');
|
||
INSERT INTO `t_student` VALUES (10093, '吴致远', 'ba5fmbCSUO', 'MMfkS9Lwr7');
|
||
INSERT INTO `t_student` VALUES (10094, '陶詩涵', '7bWA6xXp1A', 'Tlo0LxVlVH');
|
||
INSERT INTO `t_student` VALUES (10095, '曹睿', 'N08y7yJu15', '8ue93KnrvI');
|
||
INSERT INTO `t_student` VALUES (10096, '方宇宁', 't9xDmfZaEQ', 'Xm9umRA1Uc');
|
||
INSERT INTO `t_student` VALUES (10097, '曹安琪', 'vG4ZtAQanT', 'Vth5vsry9y');
|
||
INSERT INTO `t_student` VALUES (10098, '杨子异', 'YUf12JCtO6', '8999nWETCU');
|
||
INSERT INTO `t_student` VALUES (10099, '于杰宏', 'l3NbjhRoCR', 'qCPLVovMjL');
|
||
INSERT INTO `t_student` VALUES (10100, '郑震南', 'G3nVY0YbM8', 'vLRejxC1Ve');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_video
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_video`;
|
||
CREATE TABLE `t_video` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`c_id` int(10) NOT NULL,
|
||
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10145 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of t_video
|
||
-- ----------------------------
|
||
INSERT INTO `t_video` VALUES (10001, 10001, 'Navicat Monitor requires ', 'https://video.nishiminat.com/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10002, 10003, 'To successfully establish ', 'https://video.kamtl.cn/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10003, 10002, 'How we spend our days ', 'http://video.kjialun.net/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10004, 10003, 'To successfully establish ', 'https://video.hyhan56.net/Handcrafts');
|
||
INSERT INTO `t_video` VALUES (10005, 10002, 'If the Show objects under ', 'http://video.shishih.xyz/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10006, 10003, 'Anyone who has ever made ', 'https://video.anme7.com/Books');
|
||
INSERT INTO `t_video` VALUES (10007, 10002, 'To get a secure connection, ', 'http://video.manuelell60.info/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10008, 10002, 'To successfully establish ', 'http://video.imi10.us/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10009, 10003, 'It provides strong authentication ', 'https://video.miutszching.org/Appliances');
|
||
INSERT INTO `t_video` VALUES (10010, 10001, 'There is no way to happiness. ', 'http://video.vasquedwa.biz/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10011, 10001, 'Import Wizard allows ', 'http://video.stszhin.org/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10012, 10002, 'Flexible settings enable ', 'http://video.psarah.us/Others');
|
||
INSERT INTO `t_video` VALUES (10013, 10001, 'To connect to a database ', 'http://video.yamadsara.jp/Food');
|
||
INSERT INTO `t_video` VALUES (10014, 10002, 'If you wait, all that ', 'https://video.wfts1.co.jp/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10015, 10003, 'It wasn’t raining when ', 'http://video.cook77.net/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10016, 10002, 'Success consists of going ', 'http://video.zhiyuanding.us/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10017, 10003, 'In other words, Navicat ', 'https://video.waiyeesiu.biz/BeautyPersonalCare');
|
||
INSERT INTO `t_video` VALUES (10018, 10002, 'If the Show objects under ', 'http://video.sumwinglok.biz/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10019, 10001, 'I will greet this day ', 'https://video.carol3.net/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10020, 10002, 'SQL Editor allows you ', 'https://video.kad.xyz/MusicalInstrument');
|
||
INSERT INTO `t_video` VALUES (10021, 10003, 'In the Objects tab, you ', 'https://video.luj.org/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10022, 10003, 'It collects process metrics ', 'https://video.laws10.jp/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10023, 10001, 'Navicat provides powerful ', 'https://video.xiaoming9.net/Appliances');
|
||
INSERT INTO `t_video` VALUES (10024, 10002, 'A man’s best friends ', 'http://video.zhiyuliang8.jp/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10025, 10002, 'It wasn’t raining when ', 'https://video.hu1942.us/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10026, 10001, 'Anyone who has never ', 'https://video.shim.co.jp/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10027, 10001, 'The reason why a great ', 'http://video.hazukio.org/CollectiblesFineArt');
|
||
INSERT INTO `t_video` VALUES (10028, 10002, 'Creativity is intelligence having fun.', 'http://video.matsudae07.cn/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10029, 10002, 'Optimism is the one quality ', 'https://video.zhenjiang711.jp/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10030, 10001, 'A query is used to extract ', 'http://video.karyanchoi.us/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10031, 10001, 'To successfully establish ', 'http://video.kaming43.xyz/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10032, 10001, 'To successfully establish ', 'http://video.ylu321.net/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10033, 10002, 'In other words, Navicat ', 'https://video.bt10.info/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10034, 10002, 'There is no way to happiness. ', 'http://video.hung9.co.jp/ClothingShoesandJewelry');
|
||
INSERT INTO `t_video` VALUES (10035, 10002, 'The first step is as good as half over.', 'https://video.muran.jp/Baby');
|
||
INSERT INTO `t_video` VALUES (10036, 10001, 'All the Navicat Cloud ', 'http://video.gonzalezbru85.cn/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10037, 10002, 'Navicat 15 has added ', 'https://video.jesusoto.co.jp/Appliances');
|
||
INSERT INTO `t_video` VALUES (10038, 10001, 'It wasn’t raining when ', 'http://video.carant.co.jp/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10039, 10002, 'If your Internet Service ', 'http://video.edwards1.jp/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10040, 10002, 'You must be the change ', 'https://video.zhiyuan2.org/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10041, 10002, 'All journeys have secret ', 'https://video.tlwan4.net/BaggageTravelEquipment');
|
||
INSERT INTO `t_video` VALUES (10042, 10001, 'It wasn’t raining when ', 'http://video.hanzit.xyz/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10043, 10002, 'Import Wizard allows ', 'http://video.willimoore83.net/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10044, 10003, 'Navicat is a multi-connections ', 'https://video.porter620.cn/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10045, 10002, 'Navicat Data Modeler ', 'http://video.su715.com/Food');
|
||
INSERT INTO `t_video` VALUES (10046, 10001, 'Remember that failure ', 'https://video.watsonapril.jp/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10047, 10003, 'Import Wizard allows ', 'http://video.sarahriv10.xyz/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10048, 10001, 'Navicat Cloud could not ', 'http://video.medw.org/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10049, 10002, 'It collects process metrics ', 'http://video.okamomo.com/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10050, 10003, 'Navicat 15 has added ', 'http://video.renaokada.xyz/Others');
|
||
INSERT INTO `t_video` VALUES (10051, 10003, 'The On Startup feature ', 'https://video.rythomas104.info/Beauty');
|
||
INSERT INTO `t_video` VALUES (10052, 10001, 'You will succeed because ', 'http://video.saitoaoshi.co.jp/BaggageTravelEquipment');
|
||
INSERT INTO `t_video` VALUES (10053, 10001, 'Navicat is a multi-connections ', 'http://video.lzhen.info/MusicalInstrument');
|
||
INSERT INTO `t_video` VALUES (10054, 10003, 'If it scares you, it ', 'https://video.barnes722.info/MusicalInstrument');
|
||
INSERT INTO `t_video` VALUES (10055, 10002, 'HTTP Tunneling is a method ', 'http://video.man1.us/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10056, 10003, 'The On Startup feature ', 'https://video.he506.us/BeautyPersonalCare');
|
||
INSERT INTO `t_video` VALUES (10057, 10001, 'Navicat Monitor requires ', 'https://video.myam.info/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10058, 10003, 'Import Wizard allows ', 'https://video.sy7.org/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10059, 10002, 'Success consists of going ', 'https://video.itsuki521.net/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10060, 10003, 'It wasn’t raining when ', 'https://video.hsuankwokkuen1970.org/PetSupplies');
|
||
INSERT INTO `t_video` VALUES (10061, 10003, 'Remember that failure ', 'http://video.cht.us/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10062, 10003, 'The Synchronize to Database ', 'https://video.nakayama17.biz/Baby');
|
||
INSERT INTO `t_video` VALUES (10063, 10003, 'There is no way to happiness. ', 'http://video.albjohnson.net/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10064, 10003, 'SQL Editor allows you ', 'http://video.kasumiarai.co.jp/ClothingShoesandJewelry');
|
||
INSERT INTO `t_video` VALUES (10065, 10001, 'Navicat allows you to ', 'https://video.parker621.com/VideoGames');
|
||
INSERT INTO `t_video` VALUES (10066, 10001, 'SQL Editor allows you ', 'http://video.sato1222.co.jp/MusicalInstrument');
|
||
INSERT INTO `t_video` VALUES (10067, 10003, 'Difficult circumstances ', 'http://video.yli614.us/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10068, 10003, 'It wasn’t raining when ', 'http://video.miliksun.net/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10069, 10003, 'In a Telnet session, ', 'https://video.debrama.cn/AutomotivePartsAccessories');
|
||
INSERT INTO `t_video` VALUES (10070, 10001, 'If opportunity doesn’t ', 'http://video.eitamatsu.org/BaggageTravelEquipment');
|
||
INSERT INTO `t_video` VALUES (10071, 10003, 'Typically, it is employed ', 'http://video.jamesaguilar.org/Baby');
|
||
INSERT INTO `t_video` VALUES (10072, 10002, 'I will greet this day ', 'https://video.aokimis.com/Baby');
|
||
INSERT INTO `t_video` VALUES (10073, 10002, 'The repository database ', 'https://video.kasumiwa2003.cn/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10074, 10001, 'In the middle of winter ', 'https://video.phillipsj.cn/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10075, 10001, 'Difficult circumstances ', 'https://video.lli627.jp/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10076, 10001, 'It wasn’t raining when ', 'http://video.nanaminishimura7.xyz/Handcrafts');
|
||
INSERT INTO `t_video` VALUES (10077, 10001, 'A query is used to extract ', 'http://video.hasegak925.us/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10078, 10003, 'The Information Pane ', 'http://video.takasumi.jp/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10079, 10003, 'Always keep your eyes ', 'https://video.huimeicho75.info/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10080, 10002, 'In the Objects tab, you ', 'https://video.ashley66.com/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10081, 10002, 'You must be the change ', 'http://video.anqiwe.info/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10082, 10003, 'A man is not old until ', 'http://video.miuraitsuki.xyz/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10083, 10002, 'In the middle of winter ', 'http://video.sad.biz/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10084, 10003, 'Navicat Monitor can be ', 'http://video.sm513.xyz/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10085, 10001, 'Flexible settings enable ', 'http://video.rihi.xyz/PetSupplies');
|
||
INSERT INTO `t_video` VALUES (10086, 10003, 'It provides strong authentication ', 'https://video.weddie.biz/ClothingShoesandJewelry');
|
||
INSERT INTO `t_video` VALUES (10087, 10002, 'It provides strong authentication ', 'http://video.tsand.com/Baby');
|
||
INSERT INTO `t_video` VALUES (10088, 10001, 'In the middle of winter ', 'http://video.matsusakura.org/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10089, 10002, 'Instead of wondering ', 'http://video.ayato129.com/ClothingShoesandJewelry');
|
||
INSERT INTO `t_video` VALUES (10090, 10002, 'In a Telnet session, ', 'https://video.ngliksun44.net/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10091, 10001, 'In the middle of winter ', 'https://video.lanf80.cn/Books');
|
||
INSERT INTO `t_video` VALUES (10092, 10003, 'Genius is an infinite ', 'http://video.wp9.co.jp/Baby');
|
||
INSERT INTO `t_video` VALUES (10093, 10003, 'A man’s best friends ', 'https://video.tangcm1956.net/AppsGames');
|
||
INSERT INTO `t_video` VALUES (10094, 10003, 'Navicat provides powerful ', 'http://video.mingyung2018.com/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10095, 10002, 'Monitored servers include ', 'https://video.wl01.net/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10096, 10001, 'Secure SHell (SSH) is ', 'https://video.yu713.info/PetSupplies');
|
||
INSERT INTO `t_video` VALUES (10097, 10002, 'Navicat Monitor requires ', 'https://video.fongchiming901.biz/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10098, 10002, 'In other words, Navicat ', 'https://video.jose17.co.jp/Food');
|
||
INSERT INTO `t_video` VALUES (10099, 10003, 'A comfort zone is a beautiful ', 'https://video.xiayuni.biz/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10100, 10001, 'There is no way to happiness. ', 'http://video.mo1997.xyz/Beauty');
|
||
INSERT INTO `t_video` VALUES (10101, 10001, 'SSH serves to prevent ', 'http://video.lsha6.us/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10102, 10003, 'It can also manage cloud ', 'http://video.txiuy51.jp/Beauty');
|
||
INSERT INTO `t_video` VALUES (10103, 10003, 'If you wait, all that ', 'http://video.arthurmo.biz/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10104, 10001, 'The first step is as good as half over.', 'http://video.kwokyin306.org/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10105, 10003, 'Remember that failure ', 'http://video.qiuzit4.us/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10106, 10002, 'Navicat Monitor requires ', 'http://video.ricet.jp/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10107, 10002, 'To open a query using ', 'https://video.hashino.us/Others');
|
||
INSERT INTO `t_video` VALUES (10108, 10003, 'The Synchronize to Database ', 'http://video.nelsondavid10.xyz/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10109, 10003, 'Genius is an infinite ', 'https://video.lauwl1958.info/MusicalInstrument');
|
||
INSERT INTO `t_video` VALUES (10110, 10002, 'Navicat Monitor is a ', 'https://video.jia915.co.jp/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10111, 10003, 'The first step is as good as half over.', 'https://video.sanakayama.xyz/BeautyPersonalCare');
|
||
INSERT INTO `t_video` VALUES (10112, 10001, 'Export Wizard allows ', 'https://video.watam.co.jp/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10113, 10001, 'Remember that failure ', 'http://video.ntsub.biz/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10114, 10001, 'Secure Sockets Layer(SSL) ', 'http://video.tsubas.us/FilmSupplies');
|
||
INSERT INTO `t_video` VALUES (10115, 10001, 'You will succeed because ', 'https://video.moralrub.cn/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10116, 10001, 'If you wait, all that ', 'http://video.kathreynolds.biz/Appliances');
|
||
INSERT INTO `t_video` VALUES (10117, 10003, 'If the Show objects under ', 'https://video.rche.us/ClothingShoesandJewelry');
|
||
INSERT INTO `t_video` VALUES (10118, 10002, 'After logged in the Navicat ', 'http://video.sefukud3.biz/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10119, 10002, 'The reason why a great ', 'https://video.yinchiehlun.jp/CollectiblesFineArt');
|
||
INSERT INTO `t_video` VALUES (10120, 10001, 'A query is used to extract ', 'http://video.jialungu.xyz/CDsVinyl');
|
||
INSERT INTO `t_video` VALUES (10121, 10001, 'To clear or reload various ', 'http://video.soto5.cn/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10122, 10001, 'How we spend our days ', 'http://video.shingkm.xyz/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10123, 10001, 'A man is not old until ', 'https://video.karenbryant.com/ToysGames');
|
||
INSERT INTO `t_video` VALUES (10124, 10001, 'You will succeed because ', 'http://video.yanshih4.jp/BaggageTravelEquipment');
|
||
INSERT INTO `t_video` VALUES (10125, 10003, 'SQL Editor allows you ', 'http://video.fskwok4.xyz/SportsOutdoor');
|
||
INSERT INTO `t_video` VALUES (10126, 10002, 'To open a query using ', 'https://video.chenrich.cn/VideoGames');
|
||
INSERT INTO `t_video` VALUES (10127, 10003, 'Always keep your eyes ', 'http://video.hyliao6.cn/HouseholdKitchenAppliances');
|
||
INSERT INTO `t_video` VALUES (10128, 10003, 'You will succeed because ', 'https://video.mao45.org/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10129, 10001, 'I may not have gone where ', 'http://video.oghikari.net/Books');
|
||
INSERT INTO `t_video` VALUES (10130, 10003, 'It provides strong authentication ', 'https://video.onhaz2.org/VideoGames');
|
||
INSERT INTO `t_video` VALUES (10131, 10003, 'Success consists of going ', 'http://video.rikuwa.info/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10132, 10002, 'The repository database ', 'https://video.yuna9.info/AutomotivePartsAccessories');
|
||
INSERT INTO `t_video` VALUES (10133, 10002, 'All the Navicat Cloud ', 'https://video.johnngar.com/Beauty');
|
||
INSERT INTO `t_video` VALUES (10134, 10001, 'Export Wizard allows ', 'http://video.zyuan.com/HealthBabyCare');
|
||
INSERT INTO `t_video` VALUES (10135, 10003, 'The Information Pane ', 'https://video.xuerui9.biz/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10136, 10003, 'The Main Window consists ', 'https://video.ruixu.xyz/ArtsHandicraftsSewing');
|
||
INSERT INTO `t_video` VALUES (10137, 10001, 'In the middle of winter ', 'https://video.wstang.co.jp/CenturionGardenOutdoor');
|
||
INSERT INTO `t_video` VALUES (10138, 10003, 'If the plan doesn’t ', 'https://video.mc93.us/BaggageTravelEquipment');
|
||
INSERT INTO `t_video` VALUES (10139, 10002, 'It can also manage cloud ', 'https://video.ntingfung.info/ToolsHomeDecoration');
|
||
INSERT INTO `t_video` VALUES (10140, 10001, 'If the Show objects under ', 'http://video.myunxi43.info/Handcrafts');
|
||
INSERT INTO `t_video` VALUES (10141, 10001, 'If it scares you, it ', 'http://video.endh54.xyz/CellPhonesAccessories');
|
||
INSERT INTO `t_video` VALUES (10142, 10002, 'The Information Pane ', 'http://video.takwahmok9.us/IndustrialScientificSupplies');
|
||
INSERT INTO `t_video` VALUES (10143, 10002, 'To connect to a database ', 'http://video.miuramomoe.cn/Appliances');
|
||
INSERT INTO `t_video` VALUES (10144, 10002, 'Navicat is a multi-connections ', 'http://video.lishiha.net/Appliances');
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|
||
|
||
```
|
||
|
||
### 题目
|
||
|
||
|
||
|
||
|
||
|
||
### 答案
|
||
|
||
```sql
|
||
#1
|
||
CREATE TABLE t_teacher(
|
||
id INT(8) PRIMARY KEY,
|
||
`name` VARCHAR(10),
|
||
nikename VARCHAR(20),
|
||
introduce text
|
||
);
|
||
|
||
#2
|
||
INSERT INTO t_student()
|
||
VALUES(10101, '王梓星', 'username123', 'password123');
|
||
|
||
#3
|
||
DELETE FROM t_course
|
||
WHERE id = 10004;
|
||
|
||
#4
|
||
UPDATE t_video v
|
||
SET v.link = 'www.shipin.mp4'
|
||
WHERE v.id = 10005;
|
||
|
||
#5 tj11
|
||
SELECT COUNT(*) 'total_students'
|
||
FROM t_student;
|
||
|
||
#6
|
||
SELECT v.id '视频编号', v.title '标题', v.link '链接地址'
|
||
FROM t_video v, t_course c
|
||
WHERE v.c_id = c.id AND c.`name` = '语文';
|
||
|
||
#7
|
||
CREATE VIEW v_education AS
|
||
SELECT s.`name` '学生姓名', c.`name` '课程名称', l.`schedule` '学习进度', l.createtime '创建时间'
|
||
FROM t_student s, t_learn l, t_course c
|
||
WHERE s.id = l.s_id AND l.c_id = c.id;
|
||
|
||
#8
|
||
CREATE TRIGGER tri_insert_student_learn
|
||
AFTER INSERT ON t_student
|
||
FOR EACH ROW
|
||
BEGIN
|
||
INSERT INTO t_learn (s_id, c_id, schedule, createtime)
|
||
VALUES (NEW.id, 10001, 0, '2025-01-01');
|
||
END
|
||
|
||
#9
|
||
CREATE PROCEDURE `sp_get_student_courses`(
|
||
IN in_student_id INT,
|
||
OUT out_course_count INT
|
||
)
|
||
BEGIN
|
||
SELECT COUNT(DISTINCT c_id) INTO out_course_count
|
||
FROM t_learn
|
||
WHERE s_id = in_student_id ;
|
||
END
|
||
```
|
||
|