Restore one column from a backup

Question

MySQL

Hey!
There is a table like

id name email

there is a backup,

you need to restore the email table based on id, without touching the name.

really?

Answer 1

And in the forehead to restore the table next to the original one and carry out the necessary manipulations?

CREATE TABLE final SELECT t1.id, t1.name, t2.email FROM orig t1 JOIN backup t2 ON t1.id=t2.id

Answer 2

Same question on stackoverflow