mysqlexists子查询

exists后面的子查询,exists 只关怀有无，返回布尔类型

#案例：查询有员工的部门名

    SELECT department_name
FROM departments d
WHERE EXISTS(
    SELECT *
    FROM employees e
    WHERE d.`department_id`=e.`department_id`
);