I have two exact tables with different data. I need to be able to generate a Mysql View with the following:
- All new rows that don't appear in
previous_tablebut appears in
- All rows in
previous_tablethat has updated column values in
The tables don't have any primary keys. I cannot change the schema because it is out of my control.
Any help would be deeply appreciated.