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

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

CREATE TEMPORARY TABLE temp_table1 AS

SELECT *, 'table1' as source FROM table1;

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

CREATE TEMPORARY TABLE temp_table2 AS

SELECT *, 'table2' as source FROM table2;

-- 找出在兩個(gè)表中完全一致的數(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);