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%';