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.
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.
Modern web applications rarely live alone. A customer portal, an internal order-management console, or a…
An invoice lands in the accounts inbox for equipment delivered three weeks ago. The supplier…
A Google Ads management campaign can look healthy in the dashboard and still waste money…
A potential customer arrives on your website after searching for a service you provide. They…
In the business world, there’s no such thing as a new idea. The best we…
Both of these work. Both are difficult. And anyone telling you one is obviously better…