mysql_where条件

select * from employee where id > 7

2.多条件查询

# 查询post为‘teacher‘ 并且 salary 大于8000的记录。
select * from employee where post = ‘teacher‘ and salary > 8000;

3.关键字between and

# 查询salary大于等于20000和salary小于等于30000的记录。
select * from employee where salary between 20000 and 30000;

4.关键字not

# 查询id不大于7的记录。
select * from employee where not id >7;

 

mysql_where条件

标签：mysql   style   条件   bsp   直接   and   pos   等于   code