Update With Join in MySQL

Say you want to update a column of an entire table with values from another table. You can do an UPDATE with INNER JOIN. See below:

UPDATE
    tabela_1
INNER JOIN
    tabela_2 ON tabela_2.tabela_1.id = tabela_1.id
SET
    tabela_1.nome_do_campo = tabela_2.nome_do_campo

Simple!