'MYSQL Query to copy all data in a column from one database to another

I accidentally used the "Generate Description" function on my SEO Tool in Opencart and it overwrote all my product descriptions with the Product Title.

I have over 600+ products and it will be a pain to re-do them all again.

I have a MYSQL backup from 2 months ago which has most of the products except for about 20 which was added after.

I have imported the old backup to a newly created database, what query can i run to copy & overwrite all of the description column data from the backup table to my current table?

They are located in database.oc_product_description.description

Any help is greatly appreciated. This is driving me crazy



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source