mybaits的sql

/*
 Navicat Premium Data Transfer

 Source Server         : cccc
 Source Server Type    : MySQL
 Source Server Version : 50649
 Source Host           : localhost:3306
 Source Schema         : mybatis_demo

 Target Server Type    : MySQL
 Target Server Version : 50649
 File Encoding         : 65001

 Date: 09/04/2022 23:44:20
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, '赵大伟', '18849134233', '男', 1);
INSERT INTO `student` VALUES (2, '赵小伟', '18333786672', '男', 1);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称',
  `birthday` datetime(0) DEFAULT NULL COMMENT '生日',
  `sex` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
  `address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (4, '??', '2022-04-09 23:35:53', '?', '??');
INSERT INTO `user` VALUES (5, '???', '2022-04-07 22:32:12', '?', '???');
INSERT INTO `user` VALUES (6, '??', '2022-04-09 23:35:52', '?', '??');
INSERT INTO `user` VALUES (8, 'b', NULL, NULL, '??');
INSERT INTO `user` VALUES (9, 'a', NULL, NULL, '??');
INSERT INTO `user` VALUES (10, 'c', NULL, NULL, '??');
INSERT INTO `user` VALUES (11, '???', '2022-04-09 23:20:35', '?', '???');
INSERT INTO `user` VALUES (12, '???', '2022-04-09 23:27:06', '?', '???');
INSERT INTO `user` VALUES (13, '???', '2022-04-09 23:27:53', '?', '???');
INSERT INTO `user` VALUES (14, 'b', NULL, NULL, '??');
INSERT INTO `user` VALUES (15, 'a', NULL, NULL, '??');
INSERT INTO `user` VALUES (16, 'c', NULL, NULL, '??');
INSERT INTO `user` VALUES (17, '???', '2022-04-09 23:35:53', '?', '???');
INSERT INTO `user` VALUES (18, '??', '2022-04-09 23:35:54', '?', '??');
INSERT INTO `user` VALUES (19, 'b', NULL, NULL, '??');
INSERT INTO `user` VALUES (20, 'a', NULL, NULL, '??');
INSERT INTO `user` VALUES (21, 'c', NULL, NULL, '??');

SET FOREIGN_KEY_CHECKS = 1;