CREATE TABLE geoTable(
`id`
INT
(
11
)
NOT
NULL
AUTO_INCREMENT
,
`geo` GEOMETRY DEFAULT NULL ,
PRIMARY KEY ( `id` )
)
ENGINE
=
MYISAM;
`geo` GEOMETRY DEFAULT NULL ,
PRIMARY KEY ( `id` )
INSERT INTO `GPSserver`.`geoTable` (
`id`
,
`geo`
)
`geo`
VALUES (
NULL
,
GEOMFROMTEXT
(
'POINT(31.5,42.2)'
)
)
;
INSERT INTO `GPSserver`.`geoTable` (
`id`
,
`geo`
)
`geo`
VALUES (
NULL
,
GEOMFROMTEXT
(
'LINESTRING(0 0,1 1,2 2)'
)
)
;
SELECT id , ASTEXT ( geo )
FROM geoTable
LIMIT 0 , 30
http://blog.csdn.net/iwillsw/article/details/335459
http://dev.mysql.com/doc/refman/5.1/en/geometry-property-functions.html