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