编辑代码

CREATE DATABASE staff;
use staff;
CREATE TABLE employee (
	id int,
	username varchar(255),
    birthDate data,
	idCard varchar(255),
	loginName varchar(255),
    password varchar(255),
    mobile varchar(255),
    email varchar(255),
    deptId int,
    level int,
    avatar blob,
    remark text
);

INSERT INTO employee VALUES (1, '张三', '2000-06-1', '123456789','root','321','123456789','123456789@qq.com','001','1');
INSERT INTO employee VALUES (2, '李四', '2000-06-2', '123456788','root','322','123456788','123456788@qq.com','002','1');
INSERT INTO employee VALUES (3, '王五', '2000-06-3', '123456787','root','323','123456786','123456787@qq.com','002','1');
INSERT INTO employee VALUES (4, '麻子', '2000-06-4', '123456786','root','324','123456785','123456786@qq.com','002','1');
INSERT INTO employee VALUES (5, '黑子', '2000-06-5', '123456785','root','325','123456784','123456785@qq.com','002','1');

SELECT * FROM employee;