1. create database vfast; #建立一个数据库
2. use vfast;
create table zuoye (employee_id int, name char(15), gender enum('M','F'), dent_id('1','2','3','4'), jonin_time date, salary float, phone char(11), address char(30), description text); #创建用户表
3.#建立用户记录
insert into zuoye values ('1', 'Tom', 'M', '3', '2011-11-11', '5168', '110120119', 'xicheng', 'zhuli');
4.#按名字查找
select * from zuoye where name='tom';
#按照薪水查找
select * from zuoye where salary > 5000;
#计算出每个部门总人数
select dept_id,count(*) from zuoye group by dept_id;
#计算出每个部门avg薪水
select dept_id,avg(salary) from zuoye group by dept_id;
#查找出描述字段为空的员工
select * from zuoye where description is null;
#查找出每个部门女员工,薪水的最大值
select dept_id,max(salary) from zuoye where gender='F' group by dept_id;
#查找出名字为“L”开头的用户
select * from zuoye where name like 'L%';
转载于:https://blog.51cto.com/q707155804/1101641