Compare two tables in MySQL

When migrate data you need to compare two tables and identify the unmatched results records.

Suppose you have two tables table1 and table2 with same columns and values. If any one table has any extra row then using below query you can get the unmatched results.

Compare two tables:

SELECT id, name
FROM (
SELECT id, name FROM table1
UNION ALL
SELECT id, name FROM table2
) tbl
GROUP BY id, name
HAVING count(*) = 1
ORDER BY id;

Using above query you will get the unmatched row.