1. point字段
数据类型:point
数据类型说明:空间点(如车站位置)
存储案例:(Binary/Image)
具体数据形式:POINT(1 1)
SQL语句 :
set @g = “POINT(1 1)”;
Insert into user (test1) values (GeomFromText(@g));
2.polygon字段
数据类型:polygon
数据类型说明:空间区域(如城市范围,森林范围)
存储案例:(Binary/Image)
具体数据形式:POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (5 5, 7 5, 7 7, 5 7, 5 5))
SQL语句 :
set @g = “POINT(1 1)”
insert into user (test2) values (GeomFromText(@g));
3. multilinestring 字段
数据类型:multilinestring
数据类型说明:多线段(如城市道路系统)
存储案例:(Binary/Image)
具体数据形式:POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (5 5, 7 5, 7 7, 5 7, 5 5))
SQL语句
set @g = “POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (5 5, 7 5, 7 7, 5 7, 5 5))<