编辑代码

CREATE DATABASE test;
use test;
CREATE table user (
	id int,
	user_id varchar(255),
	Email varchar(255),
	password varchar(255),
    user_type varchar(255)
);

INSERT INTO user VALUES (1, '张三', 'ard@outlook.com', '32w14f','2');
INSERT INTO user VALUES (2, '李四', '172493563@qq.com', '795600','2');
INSERT INTO user VALUES (3, '王二麻子', '146739410@qq.com', '654321','2');
INSERT INTO user VALUES (4, '游客', 'null', 'null','1');
INSERT INTO user VALUES (5, 'gpf1987025', 'stu173@outlook.com', '&Dne275976s','3');

SELECT * FROM user;