How to write a SQL query to copy from one cell to another?

Question

SQL

Tell me what query to write to copy data from one cell to another for all records in one table?
for example, in the joomlajshopping_products table,
from the manufacturer_code column, copy all records to the product_ean column

Answer 1

UPDATE `joomlajshopping_products` SET `product_ean` = `manufacturer_code`