mysql 差集Except:
SELECT ID FROM (
SELECT DISTINCT A.AID AS ID FROM TABLE_A A
UNION ALL
SELECT DISTINCT B.BID AS ID FROM TABLE_B B
)TEMP GROUP BY ID HAVING COUNT(ID) = 1
查询A、B两个表中ID不同的项。
注: 如果A、B两表中有相同的项,通过count(ID)的值应该 ≥2,等于1的表示只存在于某一个表。
mysql 差集Except:
SELECT ID FROM (
SELECT DISTINCT A.AID AS ID FROM TABLE_A A
UNION ALL
SELECT DISTINCT B.BID AS ID FROM TABLE_B B
)TEMP GROUP BY ID HAVING COUNT(ID) = 1
查询A、B两个表中ID不同的项。
注: 如果A、B两表中有相同的项,通过count(ID)的值应该 ≥2,等于1的表示只存在于某一个表。