您是否要批量更新所有现有行?

Are you trying to update all of the existing rows in bulk?

如果是这样，这是进行更新的一种方法:

If so, here's one way to do the update:

update users u
  inner join zips z on z.zip = u.zip
set u.state = z.state,
  u.city = z.city;