高效mysql 两张表数据比较差异

-- 创建示例表
CREATE TABLE table1 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE TABLE table2 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

-- 插入示例数据
INSERT INTO table1 (id, name, age) VALUES (1, 'Alice', 30);
INSERT INTO table1 (id, name, age) VALUES (2, 'Bob', 25);

INSERT INTO table2 (id, name, age) VALUES (1, 'Alice', 30);
INSERT INTO table2 (id, name, age) VALUES (3, 'Charlie', 35);

-- 查询差异
SELECT * FROM table1
WHERE NOT EXISTS (
    SELECT 1 FROM table2 WHERE table1.id = table2.id AND table1.name = table2.name AND table1.age = table2.age
)
UNION ALL
SELECT * FROM table2
WHERE NOT EXISTS (
    SELECT 1 FROM table1 WHERE table2.id = table1.id AND table2.name = table1.name AND table2.age = table1.age
);