MySQL 简单查询语句练习题（4+18）

染落

已于 2022-09-05 18:04:46 修改

阅读量339

点赞数

分类专栏： SQL语句文章标签：数据库 sql mysql

于 2022-09-05 14:07:52 首次发布

本文链接：https://blog.csdn.net/q74269665/article/details/126703741

版权

简单介绍

MySQL图形化工具：SQLyog、DataGrip、Navicat、MySQL Workbench 8.0 CE
因为全是采用的三国人物名称，其中地址和年龄都没有参考历史，性别全部用'1'代替了，因为写完了发现“性别”字段是多余的。
如果遇到什么问题可以相互交流。

1、插入数据

下方代码直接复制，方便MySQL图形化工具的使用


#创建数据库examination
CREATE DATABASE IF NOT EXISTS `exercise`;
 
#使用数据库examination
USE exercise;

#创建表
create table emp(
	id int comment '编号',
	empName varchar(10) comment '员工姓名',
	gender char(1) comment '性别',
	age int comment '年龄',
	workAddress varchar(50) comment '工作地址',
    entryDate date comment '入职日期'
)comment '员工表';
 
# 插入测试数据
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (0, '荀彧', '1', 57, '许昌', '244-6-14');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (1, '荀攸', '1', 30, '徐州', '229-11-2');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (2, '贾诩', '1', 36, '荆州', '269-2-27');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (3, '郭嘉', '1', 42, '许昌', '229-11-2');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (4, '程昱', '1', 19, '徐州', '235-12-12');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (5, '戏志才', '1', 35, '襄阳', '242-7-18');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (6, '刘晔', '1', 59, '武昌', '235-12-12');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (7, '蒋济', '1', 41, '许昌', '269-2-27');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (8, '陈群', '1', 37, '襄阳', '269-2-27');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (9, '华歆', '1', 23, '武昌', '244-6-14');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (10, '钟繇', '1', 26, '徐州', '242-7-18');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (11, '满宠', '1', 51, '许昌', '242-7-18');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (12, '董昭', '1', 46, '荆州', '269-2-27');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (13, '王朗', '1', 44, '长沙', '258-9-22');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (14, '崔琰', '1', 49, '武昌', '242-7-18');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (15, '毛玠', '1', 61, '襄阳', '244-6-14');
insert into Emp (id, empName, gender, age, workAddress, entryDate) values (16, '杜畿', '1', 53, '襄阳', '233-4-6');
insert into Emp (id, empName, gender,