狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

-- 定義一個臨時表，存儲table1的所有數據以及對應的表名

CREATE TEMPORARY TABLE temp_table1 AS

SELECT *, 'table1' as source FROM table1;

-- 同理，定義一個臨時表，存儲table2的所有數據以及對應的表名

CREATE TEMPORARY TABLE temp_table2 AS

SELECT *, 'table2' as source FROM table2;

-- 找出在兩個表中完全一致的數據

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);