举例:比如想通过中间表temp_user表更新user标的age字段
用户user表:
id,name,age
1,'张三',0
2,'李四',0
temp_user表:
user_id,age
1, 20
2, 18
sql如下:
UPDATE `user` LEFT JOIN `temp_user` ON `user`.id = `temp_user`.user_id
SET `user`.age = `temp_user`.age
WHERE `user`.id = `temp_user`.user_id