人工智能2201

– Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
uname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
pwd varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

– Records of user

INSERT INTO user VALUES (‘lilei’, ‘123’);
INSERT INTO user VALUES (‘hanmeimei’, ‘11’);
INSERT INTO user VALUES (‘lucy’, ‘11’);
INSERT INTO user VALUES (‘jack’, ‘123’);
INSERT INTO user VALUES (‘threexxx’, ‘1450’);
INSERT INTO user VALUES (‘kkk’, ‘13404347907’);
INSERT INTO user VALUES (‘frank’, ‘999’);
INSERT INTO user VALUES (‘Tank’, ‘898’);
INSERT INTO user VALUES (‘111’, ‘111’);
INSERT INTO user VALUES (‘444’, ‘444’);

SET FOREIGN_KEY_CHECKS = 1;