Mysql exists后面的子查询

#初始语法

SELECT EXISTS (SELECT `department_id` FROM `employees`) AS 存在;

#判断是否存在

#查询有员工的部门名

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

#查询没有女朋友的女神信息

SELECT bo.*
FROM `boys` bo
WHERE NOT EXISTS(
	SELECT `boyfriend_id`
	FROM `beauty` AS b
	WHERE b.`boyfriend_id` = bo.`id`
);