60 lines
3.1 KiB
SQL
60 lines
3.1 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 本机
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50744
|
|
Source Host : localhost:3306
|
|
Source Schema : high-six-exam
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50744
|
|
File Encoding : 65001
|
|
|
|
Date: 18/07/2024 08:52:28
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for day01_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `day01_user`;
|
|
CREATE TABLE `day01_user` (
|
|
`eid` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生ID',
|
|
`ename` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
|
|
`sex` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生性别',
|
|
`tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生手机号',
|
|
`classid` int(11) NULL DEFAULT NULL COMMENT '学生班级',
|
|
`age` int(11) NULL DEFAULT NULL COMMENT '学生年龄',
|
|
`sal` double NULL DEFAULT NULL COMMENT '学生薪资',
|
|
PRIMARY KEY (`eid`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of day01_user
|
|
-- ----------------------------
|
|
INSERT INTO `day01_user` VALUES (1, '方王韬', '男', '19800670755', 20, 29, 3059.6);
|
|
INSERT INTO `day01_user` VALUES (2, '林詩涵', '女', '19507931194', 20, 23, 6381.17);
|
|
INSERT INTO `day01_user` VALUES (3, '尹致远', '男', '7600451038', 20, 19, 5107.62);
|
|
INSERT INTO `day01_user` VALUES (4, '徐璐', '女', '7691120789', 20, 27, 5307.63);
|
|
INSERT INTO `day01_user` VALUES (5, '尹震南', '男', '14796746974', 4, 29, 6519.92);
|
|
INSERT INTO `day01_user` VALUES (6, '范致远', '男', '1053148944', 30, 29, 2720.74);
|
|
INSERT INTO `day01_user` VALUES (7, '贾子异', '男', '17787973788', 30, 24, 3940.03);
|
|
INSERT INTO `day01_user` VALUES (8, '魏震南', '男', '1009556234', 30, 24, 8387.14);
|
|
INSERT INTO `day01_user` VALUES (9, '莫子韬', '男', '7693373552', 30, 27, 9213.19);
|
|
INSERT INTO `day01_user` VALUES (10, '严子异', '男', '14145386982', 30, 23, 2418.38);
|
|
INSERT INTO `day01_user` VALUES (11, '熊子异', '男', '17999840481', 30, 30, 5356.33);
|
|
INSERT INTO `day01_user` VALUES (12, '韩宇宁', '男', '2014651275', 30, 19, 8295.86);
|
|
INSERT INTO `day01_user` VALUES (13, '陈致远', '男', '16175133202', 30, 20, 8203.2);
|
|
INSERT INTO `day01_user` VALUES (14, '田子韬', '男', '7604233014', 30, 19, 4959.46);
|
|
INSERT INTO `day01_user` VALUES (15, '王嘉伦', '男', '15315936551', 30, 27, 7611.77);
|
|
INSERT INTO `day01_user` VALUES (16, '袁詩涵', '女', '18861365288', 30, 21, 2944.04);
|
|
INSERT INTO `day01_user` VALUES (17, '姜詩涵', '女', '287949657', 30, 28, 8114.72);
|
|
INSERT INTO `day01_user` VALUES (18, '侯云熙', '男', '210309388', 30, 22, 2190.1);
|
|
INSERT INTO `day01_user` VALUES (19, '王震南', '男', '7559535493', 3, 26, 2724.84);
|
|
INSERT INTO `day01_user` VALUES (20, '谭璐', '女', '17955237156', 1, 21, 4140.22);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|