/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 80013
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 80013
File Encoding : 65001
Date: 2020-10-26 21:14:40
*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for user-- ----------------------------DROPTABLEIFEXISTS`user`;CREATETABLE`user`(`id`int(10)NOTNULLAUTO_INCREMENT,`username`varchar(20)CHARACTERSET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULTNULL,`password`varchar(20)DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=11DEFAULTCHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;-- ------------------------------ Records of user-- ----------------------------INSERTINTO`user`VALUES('1','zhangsan','1234');INSERTINTO`user`VALUES('2','lisi','1234');INSERTINTO`user`VALUES('4','shu','123');INSERTINTO`user`VALUES('5','shu1','123');
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 80013
Source Host : localhost:3306
Source Database : test1
Target Server Type : MYSQL
Target Server Version : 80013
File Encoding : 65001
Date: 2020-10-26 21:14:50
*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for student-- ----------------------------DROPTABLEIFEXISTS`student`;CREATETABLE`student`(`id`int(11)NOTNULLAUTO_INCREMENT,`username`varchar(50)CHARACTERSET utf8 COLLATE utf8_general_ci DEFAULTNULL,`sex`varchar(50)CHARACTERSET utf8 COLLATE utf8_general_ci DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=8DEFAULTCHARSET=utf8 ROW_FORMAT=DYNAMIC;-- ------------------------------ Records of student-- ----------------------------INSERTINTO`student`VALUES('1','shu','男');