MySQL中将经纬度字段转Geometry字段

 

update station set shape = ST_GeomFromText(CONCAT( 'POINT(', x, ' ', y, ')' ));

 

CONCAT( 'POINT(', x, ' ', y, ')' )

select * from station