Update from one table to another with condition in MySQL

In MySQL, you can update fields of one table from another table with a conditional statement also.

For example, you have two tables i.e. “user_activity” and “user”. And you need to update a column in one table to the value of another column where an user_id matches in both tables.

So, in a single query you can update fields of one table from another table.

UPDATE user_activity, user
SET user_activity.company_id = user.company_id
WHERE  user_activity.user_id = user.user_id