I have two database tables TAB1 TAB2 both in MYSQL server database.
Both tables have identical field names and data types as below:
I need to UPDATE all the values of F2 field (TIMESTAMP values) in TAB2 with the
correct values of F2 field in TAB1 (where rest of the record contents match in both tables).
There are NO primary keys in the tables.
TAB2 has ~800K records and TAB1 has ~900K records.
All the entries (with incorrect F1 field values) in TAB1
should ideally be in the TAB2 table.
What should be the best way to make this update?
Performance of the update query seems to be a big problem.