compare tables

Sometimes you may need to compare two tables in MySQL to find unmatched records or matched records. Here’s how to compare two tables in MySQL.