How does mysql implement multi-table joint update?

In the background development process, we sometimes need to update the fields of one table to the fields of another table. in this case, the problem of multi-table joint update is involved, this article uses cases to explain how to implement mysql multi-table joint update. For more information about the coders, see. The example is as follows:

There is a user table and a userinfo table. Update a remark field in the userinfo table to the remark field in the user table.

How can this problem be solved? MySQL multi-table joint update is used here.

Update user, userinfo set user. remark = userinfo. remark where user. id = userinfo. id

Note: Here, we assume that the user table and the userinfo table have a unique id for association.