目录
一、基础的增删改
表:t_mysql_employees
下面展示表的数据
增加
** INSERT into t_mysql_employees(first_name,last_name,email,phone_number,salary,commission_pct,manager_id,hiredate)**
修改
update t_mysql_employees set last_name = ‘cheng’ where phone_number=‘17374314552’
删除
delete from t_mysql_employees where phone_number=‘17374314552’
二、过滤查询
1、按条件表达式筛选
案例:
①、查询工资>12000的员工信息
select * from t_mysql_employees where salary >12000
②、查询部门编号不等于90号的员工名和部门编号
select last_name,department_id from t_mysql_employees where department_id <> 90
2、按逻辑表达式筛选
案例:
①、查询工资z在10000到20000之间的员工名、工资以及奖金
SELECT last_name,salary,commission_pct from t_mysql_employees where salary BETWEEN 10000 and 20000
②、查询部门编号不是在90到110之间,或者工资高于15000的员工信息
SELECT * FROM t_mysql_employees WHERE not(department_id BETWEEN 90 and 110) or salary > 15000
三、模糊查询
1、like
案例1:查询员工名中包含字符a的员工信息
select * from t_mysql_employees where last_name like '%a%'