What is the method for updating multiple tables in MySQL?

In MySQL, the JOIN clause can be used to perform multi-table update operations. Here is an example:

Assuming there are two tables: table1 and table2, both with a common field id. To update a column in table1, you can use the following SQL statement.

UPDATE table1
JOIN table2 ON table1.id = table2.id
SET table1.column_name = new_value
WHERE condition;

In this SQL statement, table1 and table2 are first connected using the JOIN clause, the SET clause is then used to update the data in table1, and finally the WHERE clause is used to specify the updating conditions.

It is important to ensure the correctness of the join conditions when performing multi-table update operations to avoid mistakenly updating data.