I have two tables and I would like to replace a part of values from table1's column with values from table2's column.

To better explain:
[![enter image description here](https://i.stack.imgur.com/IjBSq.png)](https://i.stack.imgur.com/IjBSq.png)
I would like to put values in column "name" from table2 to column "name" in table1 on rows with id 3-9. 

I'm working in Mysql workbench and MariaDB.