几个MYSQL查询实例

查询表1和表2两个表内不同的异数集合

SELECT `姓名`,`电话`,`证件号码`
FROM (
    SELECT  `姓名`,`电话`,`证件号码` FROM t1
    UNION ALL
    SELECT `姓名`,`电话`,`证件号码` FROM t2
) tbl
GROUP BY  `姓名`
HAVING count(*) = 1
ORDER BY `姓名`;

查询表内包含数

SELECT * FROM t2
WHERE 
    NOT  EXISTS  ( 
        SELECT 1 
        FROM t1
        WHERE t1.`姓名` = t2.`姓名` );