文档介绍:Mysqlgis空间数据库功能详解学****mysqlgis中文:http://dev./doc/refman/-extensions-in-#gis-class-polygon 下文为收集资料整理后,并测试后结果当前只有MyISAM引擎的数据表支持地理空间数据的存储建表:CREATE DATABASE geodatabase;USE geodatabase;CREATE TABLE test(  id INT PRIMARY KEY AUTO_INCREMENT,  name VARCHAR(128) NOT NULL,  pnt POINT,  line LINESTRING,  pgn POLYGON)ENGINE=MyISAM;添加空间列,在geom表里添加可以存储point类型数据ALTERTABLEgeomADDptPOINT;用以下SQL插入一条空间数据INSERT INTO `test` VALUES(null,'a test string',POINTFROMTEXT('POINT(15 20)'),LINESTRINGFROMTEXT('LINESTRING(0 0, 10 10, 20 25, 50 60)'),POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, 5 5))'));这里也可以用通行的GEOMFROMTEXT函数实现WKT到数据库内部几何格式的转换。而GEOMFROMWKB函数用于转换WKB。INSERTINTO`gis`VALUES(null,'ateststrin222g',GEOMFROMTEXT('POINT(1520)'),GEOMFROMTEXT('LINESTRING(00,1010,2025,5060)'),GEOMFROMTEXT('POLYGON((00,100,1010,010,00),(55,75,77,57,55))'))这个函数很有用:EnvelopeEnvelope(g)      返回几何值g的最小边界矩形(MBR)。结果以Polygon值的形式返回。多边形(polygon)是由边界框的顶点定义的:POLYGON((MINXMINY,MAXXMINY,MAXXMAXY,MINXMAXY,MINXMINY))mysql>SELECTAsText(Envelope(GeomFromText('LineString(11,22)')));+-------------------------------------------------------+|AsText(Envelope(GeomFromText('LineString(11,22)')))|+-------------------------------------------------------+|POLYGON((11,21,22,12,11))|+-------------------------------------------------------+或者多个点面集合:SELECTAsText(Envelope(GeomFromText('GeometryCollection(Poin