MYSQL GeomFromText 空间数据操作

CREATE TABLE geoTable(

`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`geo` GEOMETRY DEFAULT NULL ,
PRIMARY KEY ( `id` )

) ENGINE = MYISAM;

INSERT INTO `GPSserver`.`geoTable` (

`id` ,
`geo`

)
VALUES (

NULL , GEOMFROMTEXT( 'POINT(31.5,42.2)' )

);

INSERT INTO `GPSserver`.`geoTable` (

`id` ,
`geo`

)
VALUES (

NULL , GEOMFROMTEXT( 'LINESTRING(0 0,1 1,2 2)' )

);

SELECT id, ASTEXT( geo ) 
FROM geoTable

LIMIT 0 , 30

http://blog.youkuaiyun.com/iwillsw/article/details/335459

http://dev.mysql.com/doc/refman/5.1/en/geometry-property-functions.html