select再update update中使用select查询出的数据-通用模式: update a inner join (select * from b) c on a.id = c.id set a.xx = c.xxx