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;