MySQL中Geometry相關(guān)的SQL語(yǔ)句有哪些

小樊
97
2024-08-15 10:25:37
欄目: 云計(jì)算

  1. 創(chuàng)建Geometry類型的列：
CREATE TABLE table_name (
    geom_column_name GEOMETRY
);
  1. 插入Geometry類型的數(shù)據(jù)：
INSERT INTO table_name (geom_column_name) VALUES (ST_GeomFromText('POINT(x y)'));
  1. 查詢Geometry類型的數(shù)據(jù)：
SELECT ST_AsText(geom_column_name) FROM table_name;
  1. 計(jì)算Geometry對(duì)象的面積：
SELECT ST_Area(geom_column_name) FROM table_name;
  1. 計(jì)算Geometry對(duì)象的周長(zhǎng)：
SELECT ST_Perimeter(geom_column_name) FROM table_name;
  1. 判斷Geometry對(duì)象是否相交：
SELECT ST_Intersects(geom_column_name1, geom_column_name2) FROM table_name;
  1. 計(jì)算Geometry對(duì)象之間的距離：
SELECT ST_Distance(geom_column_name1, geom_column_name2) FROM table_name;
  1. 計(jì)算Geometry對(duì)象的交集：
SELECT ST_Intersection(geom_column_name1, geom_column_name2) FROM table_name;

這些是MySQL中常用的Geometry相關(guān)的SQL語(yǔ)句，可以用來(lái)操作和計(jì)算Geometry類型的數(shù)據(jù)。

0 踩