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
+1
source to share