Original table is table1 and backup table is table2. UPDATE table1 t1 JOIN table2 t2 ON t1.id = t2.id SET ...
stackoverflow.com