经纬转换成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
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/justuntil/p/8616675.html