DQL查询案例汇总
#创建一个表和填入数据
create table emp6
(
id int comment '编号',
workno varchar(10) comment '工号',
name varchar(5) comment '姓名',
gender char(1) comment '性别',
age tinyint unsigned comment '年龄',
idcard char(18) comment '身份证号',
workaddress varchar(50) comment '工作地址',
entrydate date comment '入职时间'
) comment '员工信息表';
insert into emp6(id, workno, name, gender, age, idcard, workaddress, entrydate)
VALUES (1, '1', '嫦娥', '女', 30, '123456789012345678', '北京', '2000-01-01'),
(2, '2', '张飞', '男', 18, '123456789012345670', '北京', '2005-09-01'),
(3, '3', '李坤', '女', 38, '123456789012345670', '上海', '2005-08-01'),
(4, '4', '赵路',