计算机2201

/*
Navicat MySQL Data Transfer

Source Server : 8
Source Server Version : 80032
Source Host : localhost:3306
Source Database : shixun

Target Server Type : MYSQL
Target Server Version : 80032
File Encoding : 65001

Date: 2023-06-26 17:13:55
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int NOT NULL AUTO_INCREMENT,
username varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
password varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

– Records of user

INSERT INTO user VALUES (‘1’, ‘lilei’, ‘123456’);
INSERT INTO user VALUES (‘2’, ‘hanmeimei’, ‘666’);
INSERT INTO user VALUES (‘3’, ‘hanmeimei’, ‘666’);
INSERT INTO user VALUES (‘4’, ‘hanmeimei’, ‘666’);
INSERT INTO user VALUES (‘5’, ‘andsfg’, ‘123’);
INSERT INTO user VALUES (‘6’, null, null);
INSERT INTO user VALUES (‘7’, null, null);
INSERT INTO user VALUES (‘8’, null, null);
INSERT INTO user VALUES (‘9’, null, null);
INSERT INTO user VALUES (‘10’, ‘lal’, ‘121212’);
INSERT INTO user VALUES (‘11’, ‘hhhhh’, ‘15978’);
INSERT INTO user VALUES (‘12’, ‘xiao’, ‘123333’);
INSERT INTO user VALUES (‘13’, ‘jixian’, ‘123456’);
INSERT INTO user VALUES (‘14’, ‘lilei’, ‘123456’);
INSERT INTO user VALUES (‘15’, ‘asd’, ‘asd’);
INSERT INTO user VALUES (‘16’, ‘heihei’, ‘123456’);
INSERT INTO user VALUES (‘17’, ‘xiaohuo’, ‘123456’);
INSERT INTO user VALUES (‘18’, ‘lilei’, ‘123456’);
INSERT INTO user VALUES (‘19’, ‘lilei’, ‘123456’);
INSERT INTO user VALUES (‘20’, ‘asd’, ‘asd’);
INSERT INTO user VALUES (‘21’, ‘sas’, ‘sad’);
INSERT INTO user VALUES (‘22’, ‘lilei’, ‘123’);