mysql中minus函数

SELECT * FROM employees
EXCEPT
SELECT * FROM managers;

-- 创建示例表
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    role VARCHAR(50)
);

CREATE TABLE managers (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    department VARCHAR(50)
);

-- 插入示例数据
INSERT INTO employees (id, name, role) VALUES
(1, 'Alice', 'Developer'),
(2, 'Bob', 'Designer'),
(3, 'Charlie', 'Manager');

INSERT INTO managers (id, name, department) VALUES
(3, 'Charlie', 'Engineering');

-- 使用 EXCEPT 查询
SELECT * FROM employees
EXCEPT
SELECT * FROM managers;