MySQL 8.4 Release Notes
存储在表中的几何值可以以内部格式获取。您还可以将它们转换为 WKT 或 WKB 格式。Geometry values stored in a table can be fetched in internal format. You can also convert them to WKT or WKB format.
以内部格式获取空间数据：Fetching spatial data in internal format:
使用内部格式获取几何值在表与表之间传输时可能很有用：Fetching geometry values using internal format can be useful in table-to-table transfers:
CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom;
以 WKT 格式获取空间数据：Fetching spatial data in WKT format:
ST_AsText()函数将几何体从内部格式转换为 WKT 字符串。TheST_AsText()function converts a geometry from internal format to a WKT string.SELECT ST_AsText(g) FROM geom;
获取 WKB 格式的空间数据：Fetching spatial data in WKB format:
ST_AsBinary()函数将几何体从内部格式转换为包含 WKB 值的BLOB。TheST_AsBinary()function converts a geometry from internal format to aBLOBcontaining the WKB value.SELECT ST_AsBinary(g) FROM geom;