SELECT id,name FROM ( SELECT id, name FROM t1 UNION ALL SELECT id,name FROM t2 ) tbl GROUP BY id, name HAVING count(*) = 1 ORDER BY id;
mysql对比两张表,查出不同数据
最新推荐文章于 2024-07-21 03:28:48 发布
SELECT id,name FROM ( SELECT id, name FROM t1 UNION ALL SELECT id,name FROM t2 ) tbl GROUP BY id, name HAVING count(*) = 1 ORDER BY id;