MySQL 坐标SQL

POLYGON类型 

UPDATE 表名 SET 字段名 = ST_GeomFromText('POLYGON((121.6282945 38.9181714, 121.6382945 38.9181714, 121.6382945 38.9281714, 121.6282945 38.9291714, 121.6282945 38.9181714))')  WHERE id = 1
SELECT st_astext(字段名) FROM 表名

POINT类型 

UPDATE 表名 SET 字段名 = st_GeomFromText('POINT(116.403322 39.920255)')
SELECT st_x(st_GeomFromText(st_astext(字段名))) AS X , st_y(st_GeomFromText(st_astext(字段名))) AS y FROM 表名