2019年5月7日
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 阅读全文
posted @ 2019-05-07 10:39 黄忠 阅读(756) 评论(0) 推荐(0) 编辑