MySQL 根据一个表的数据批量更新另一个表

---

1-常规更新

UPDATE customer c,
 area a
SET c.sell_before_man = a.sell_before_man
WHERE
	a.`name` = c.`name`

---

2-子查询更新

UPDATE sys_user_bak AS usr
SET usr.user_name = (
	SELECT
		user_name
	FROM
		sys_user_name AS nam
	WHERE
		usr.user_account = nam.user_account
)

---