计算机2203

– 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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

– Records of user

INSERT INTO user VALUES (‘3’, ‘lucy’, ‘123456’);
INSERT INTO user VALUES (‘4’, ‘sdads’, ‘ads’);
INSERT INTO user VALUES (‘5’, ‘sdads’, ‘ads’);
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’, ‘’, ‘’);
INSERT INTO user VALUES (‘11’, ‘lili’, ‘123456’);
INSERT INTO user VALUES (‘12’, ‘asd’, ‘123456’);
INSERT INTO user VALUES (‘13’, ‘qq’, ‘123456’);
INSERT INTO user VALUES (‘14’, ‘ht’, ‘12345’);
INSERT INTO user VALUES (‘15’, ‘sz’, ‘123456’);
INSERT INTO user VALUES (‘16’, ‘xiiaoming’, ‘123456’);
INSERT INTO user VALUES (‘17’, ‘qwerty’, ‘123456’);
INSERT INTO user VALUES (‘18’, ‘qwert’, ‘12345’);
INSERT INTO user VALUES (‘19’, ‘qwert’, ‘12345’);
INSERT INTO user VALUES (‘20’, ‘’, ‘’);
INSERT INTO user VALUES (‘21’, ‘qwert’, ‘12345’);
INSERT INTO user VALUES (‘22’, ‘qwert’, ‘12345’);
INSERT INTO user VALUES (‘23’, ‘qwert’, ‘12345’);