#建表
create table emp(
    id int comment'编号',
    workno varchar(10) comment'工号',
    name varchar(10) comment'姓名',
    gender char(3) comment'性别',
    age tinyint unsigned comment'年龄',
    idcard char(8) comment'身份证号',
    entrydate date comment'入职时间'
)comment'入职时间表';


#插入数据
insert into emp values (1,'001','李华','男',18,'12345678','2021-02-12'),
(2,'002','小明','男',22,'12345679','2023-04-12'),
(3,'003','李丽','女',34,'12345670','2024-07-15'),
(4,'004','张刚','男',28,'12345671','2025-02-12'),
(5,'005','王红','女',34,'12345672','2025-04-16'),
(6,'006','陈宏','男',45,'12345673','2026-01-18');