I have two database tables TAB1 TAB2 both in MYSQL server database.
Both tables have identical field names and data types as below:
F1 SMALLINT
F2 TIMESTAMP
F3 CHAR
F4 VARCHAR
F5 INT
F6 INT
F7 INT
F8 VARCHAR
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.