sql语句将数据库字段内容互换
UPDATE address_points AS a, address_points AS b
SET a.lat=b.lon ,a.lon=b.lat WHERE a.mid=b.mid AND a.cnty="中国" AND CAST(a.lat AS SIGNED)>CAST(a.lon AS SIGNED)
UPDATE address_points AS a, address_points AS b
SET a.lat=b.lon ,a.lon=b.lat WHERE a.mid=b.mid AND a.cnty="中国" AND CAST(a.lat AS SIGNED)>CAST(a.lon AS SIGNED)
