-- 定義一個臨時表，存儲table1的所有數(shù)據(jù)以及對應(yīng)的表名

CREATE TEMPORARY TABLE temp_table1 AS

SELECT *, 'table1' as source FROM table1;

-- 同理，定義一個臨時表，存儲table2的所有數(shù)據(jù)以及對應(yīng)的表名

CREATE TEMPORARY TABLE temp_table2 AS

SELECT *, 'table2' as source FROM table2;

-- 找出在兩個表中完全一致的數(shù)據(jù)

SELECT *

FROM (

    SELECT * FROM temp_table1

    UNION ALL

    SELECT * FROM temp_table2

) AS combined_tables

GROUP BY A, B, C

HAVING COUNT(*) = 2;

-- 查找只存在于table1但不在table2中的記錄

SELECT * FROM table1

WHERE NOT EXISTS (SELECT 1 FROM table2 WHERE table2.A = table1.A AND table2.B = table1.B AND table2.C = table1.C);

-- 查找只存在于table2但不在table1中的記錄

SELECT * FROM table2

WHERE NOT EXISTS (SELECT 1 FROM table1 WHERE table1.A = table2.A AND table1.B = table2.B AND table1.C = table2.C);