MySQL-DQL-条件查询笔记实例
#创建emp1表
create table emp1
(
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 emp1(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, '123456789