How to update a column of a second sql table?

Question

MySQL

Table 1
id | file_id | filename | ...
Table 2
id | file_id | ...
Need to move the file_name column to the 2nd table by matching file_id (not a key)

Answer 1

Would you like to translate from Russian into SQL? "Update" - update, "second table" - join, "by coincidence" - where.

Answer 2

Show your code example, what worked and what didn't work.
And we will help you further.