数据仓库服务 GAUSSDB(DWS)-空间数据类型:类型对照
类型对照
MySQL空间数据类型 |
MySQL INPUT |
GaussDB (DWS) OUTPUT |
---|---|---|
GEOMETRY |
GEOMETRY |
GEOMETRY |
POINT |
POINT |
POINT |
LINESTRING |
LINESTRING |
POLYGON |
POLYGON |
POLYGON |
POLYGON |
MULTIPOINT |
MULTIPOINT |
BOX |
MULTILINESTRING |
MULTILINESTRING |
BOX |
MULTIPOLYGON |
MULTIPOLYGON |
POLYGON |
GEOMETRYCOLLECTION |
GEOMETRYCOLLECTION |
GEOMETRYCOLLECTION |
- GEOMETRY可以存储任何类型的几何值。其他单值类型(POINT, LINESTRING和POLYGON)将其值限制为特定的几何类型。
- GEOMETRYCOLLECTION可以存储任何类型的对象的集合。其他集合类型(MULTIPOINT, MULTILINESTRING, MULTIPOLYGON,和 GEOMETRYCOLLECTION)限制集合成员向那些具有特定的几何形状的类型。
-
1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE TABLE `t_geo_test2` ( `id` int(11) NOT NULL, `name` varchar(255), `geometry_1` geometry NOT NULL, `point_1` point NOT NULL, `linestring_1` linestring NOT NULL, `polygon_1` polygon NOT NULL, `multipoint_1` multipoint NOT NULL, `multilinestring_1` multilinestring NOT NULL, `multipolygon_1` multipolygon NOT NULL, `geometrycollection_1` geometrycollection NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB;
输出示例
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
CREATE TABLE "public"."t_geo_test2" ( "id" INTEGER(11) NOT NULL, "name" VARCHAR(255), "geometry_1" GEOMETRY NOT NULL, "point_1" POINT NOT NULL, "linestring_1" POLYGON NOT NULL, "polygon_1" POLYGON NOT NULL, "multipoint_1" BOX NOT NULL, "multilinestring_1" BOX NOT NULL, "multipolygon_1" POLYGON NOT NULL, "geometrycollection_1" GEOMETRYCOLLECTION NOT NULL, PRIMARY KEY ("id") ) WITH ( ORIENTATION = ROW, COMPRESSION = NO ) NOCOMPRESS DISTRIBUTE BY HASH ("id");
- 数据仓库服务GaussDB(DWS)_SQL on Anywhere
- DWS安全_数据仓库服务安全_DWS数据安全管理_DWS安全保障_DWS安全策略
- 调用GaussDB(DWS) API接口_数据仓库服务调用API_如何调用API_在DWS中调用API
- GaussDB求日期差_GaussDB数据类型_高斯数据库求日期差-华为云
- GaussDB(DWS)常用SQL_常用SQL命令_SQL语法
- GaussDB数据库空间规格_GaussDB文档_高斯数据库空间规格
- DWS资源管理_GaussDB(DWS)资源管理作用_DWS资源管控
- GAUSS(DWS)工具_gsql工具_DataStudio工具_DSC工具
- DWS产品介绍_DWS产品优势_DWS功能_DWS使用场景_DWS是什么
- GaussDB数据库怎么转换类型_GaussDB安装_高斯数据库转换类型