Mysql finds unmatched records from two similar tables

I have two tables i.e. table 1 and table2. The only difference between these tables is that Table2 contains additional columns create_date and last_updated_date. Every week, Table1 records are updated or inserted. These changes should be reflected in Table 2. We are using Table2 to get the latest records using max (last_updated_date). Thus, we need a query to compare the two tables and make the necessary changes to table2 based on table 1. Thanks in advance.

+3


source to share


1 answer


Based on your request, you can link to these links, hope it helps.

http://www.mysqltutorial.org/compare-two-tables-to-find-unmatched-records-mysql.aspx



Compare two SQL tables and return missing ids?

+1


source







All Articles