经纬转换成point的sql

 

1.UPDATE xx.zd_kakou_info t,(SELECT kakou_id, kakou_lon,kakou_lat,CONCAT('POINT(' , kakou_lon ,' ',kakou_lat,')') as point from xx.zd_kakou_info) k
SET kakou_point = GeomFromText(k.point) where t.kakou_id=k.kakou_id

2.SELECT  kakou_id, kakou_lon,kakou_lat,CONCAT('POINT(' , kakou_lon ,' ',kakou_lat,')') as point from xx.zd_kakou_info

 

posted @ 2018-03-21 14:03  暗渡陈仓xy  阅读(346)  评论(0)  编辑  收藏  举报