两种方式
-- 第一种方式
update store as a, store as b
set a.city_id=b.region_id,
a.region_id=b.city_id
where a.id = b.id
and a.id in (1)and b.id in (1);
-- 第二种方式
update store set city_id=(@t:=store.city_id), city_id=region_id, region_id =@t where id = 1;