mysql 逻辑与,Java培训MySQL的运算符之逻辑运算符

#三、逻辑运算符

#与&&，或||，非!

#与 AND，或 OR ，非 NOT，异或 XOR

#查询性别男，并且在90以前出生的员工

SELECT * FROM t_employee WHERE gender=’男’ AND birthday

#查询职位编号job_id是1或2的员工

SELECT * FROM t_employee WHERE job_id =1 OR job_id = 2;

#查询基本薪资是在9000-12000之间的员工编号和基本薪资

SELECT eid,basic_salary FROM t_salary WHERE basic_salary >=9000 AND basic_salary<=12000;

#查询基本薪资不在9000-12000之间的员工编号和基本薪资

SELECT eid,basic_salary FROM t_salary WHERE NOT (basic_salary >=9000 AND basic_salary<=12000);

SELECT eid,basic_salary FROM t_salary WHERE basic_salary <9000 OR basic_salary>12000;