mysql 两列互转
标签：gps git color nbsp style blog mys div date
mysql 两列互转
tm_position as a,tm_position as b
SET
a.gps_longitude = b.gps_latitude,a.gps_latitude=b.gps_longitude
WHERE a.id=b.id AND a.gps_longitude < 50 AND a.gps_longitude >0;