How to update data from one table to another?

Question

PHP

Good day, comrades! Please advise on the best way to do it.
The goal is to update data from one table to another. From temporary to permanent.
Here is the code I generated but it doesn't work:

UPDATE `price` INNER JOIN `tmp_price` ON `price`.`name` = `tmp_price`.`name` SET `price`.`n_price` = `tmp_price`.`p` WHERE `price`.`name` = `tmp_price`.`name`"

You are welcome