| |  编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 143 | 143 |
EXTERIORRING |
2 |
ExteriorRing(poly)
Returns the exterior ring of t... |
MariaDB> SET @poly =
-> 'Polygon((0 0,0 3,3 3,...
|
https://mariadb.com/kb/en/exteriorring/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 325 | 325 |
AREA |
2 |
Area(poly)
Returns as a double-precision number t... |
MariaDB> SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1...
|
https://mariadb.com/kb/en/area/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 402 | 402 |
NUMINTERIORRINGS |
2 |
NumInteriorRings(poly)
Returns the number of inte... |
MariaDB> SET @poly =
-> 'Polygon((0 0,0 3,3 3,...
|
https://mariadb.com/kb/en/numinteriorrings/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 403 | 403 |
INTERIORRINGN |
2 |
InteriorRingN(poly,N)
Returns the N-th interior r... |
MariaDB> SET @poly =
-> 'Polygon((0 0,0 3,3 3,...
|
https://mariadb.com/kb/en/interiorringn/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 56 | 56 |
LINEFROMTEXT |
3 |
LineFromText(wkt[,srid]), LineStringFromText(wkt[,... |
|
https://mariadb.com/kb/en/linefromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 107 | 107 |
MLINEFROMTEXT |
3 |
MLineFromText(wkt[,srid]), MultiLineStringFromText... |
|
https://mariadb.com/kb/en/mlinefromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 178 | 178 |
ASTEXT |
3 |
AsText(g), AsWKT(g)
Converts a value in internal ... |
MariaDB> SET @g = 'LineString(1 1,2 2,3 3)';
Maria...
|
https://mariadb.com/kb/en/astext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 201 | 201 |
MPOLYFROMTEXT |
3 |
MPolyFromText(wkt[,srid]), MultiPolygonFromText(wk... |
|
https://mariadb.com/kb/en/mpolyfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 246 | 246 |
GEOMCOLLFROMTEXT |
3 |
GeomCollFromText(wkt[,srid]), GeometryCollectionFr... |
|
https://mariadb.com/kb/en/geomcollfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 247 | 247 |
WKT DEFINITION |
3 |
The Well-Known Text (WKT) representation of Geomet... |
|
https://mariadb.com/kb/en/wkt-definition/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 360 | 360 |
POINTFROMTEXT |
3 |
PointFromText(wkt[,srid])
Constructs a POINT valu... |
|
https://mariadb.com/kb/en/pointfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 395 | 395 |
POLYFROMTEXT |
3 |
PolyFromText(wkt[,srid]), PolygonFromText(wkt[,sri... |
|
https://mariadb.com/kb/en/polyfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 411 | 411 |
GEOMFROMTEXT |
3 |
GeomFromText(wkt[,srid]), GeometryFromText(wkt[,sr... |
|
https://mariadb.com/kb/en/geomfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 425 | 425 |
MPOINTFROMTEXT |
3 |
MPointFromText(wkt[,srid]), MultiPointFromText(wkt... |
|
https://mariadb.com/kb/en/mpointfromtext/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 49 | 49 |
ROUND |
4 |
Syntax:
ROUND(X), ROUND(X,D)
Rounds the argument ... |
MariaDB> SELECT ROUND(-1.23);
-> -1
MariaD...
|
https://mariadb.com/kb/en/round/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 90 | 90 |
ABS |
4 |
Syntax:
ABS(X)
Returns the absolute value of X.
... |
MariaDB> SELECT ABS(2);
-> 2
MariaDB> SELE...
|
https://mariadb.com/kb/en/abs/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 98 | 98 |
* |
4 |
Syntax:
*
Multiplication:
URL: https://mariadb.c... |
MariaDB> SELECT 3*5;
-> 15
MariaDB> SELECT...
|
https://mariadb.com/kb/en/multiplication-operator/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 113 | 113 |
MOD |
4 |
Syntax:
MOD(N,M), N % M, N MOD M
Modulo operation... |
MariaDB> SELECT MOD(234, 10);
-> 4
MariaDB...
|
https://mariadb.com/kb/en/mod/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 131 | 131 |
CONV |
4 |
Syntax:
CONV(N,from_base,to_base)
Converts number... |
MariaDB> SELECT CONV('a',16,2);
-> '1010'
...
|
https://mariadb.com/kb/en/conv/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 153 | 153 |
RAND |
4 |
Syntax:
RAND(), RAND(N)
Returns a random floating... |
MariaDB> CREATE TABLE t (i INT);
Query OK, 0 rows ...
|
https://mariadb.com/kb/en/rand/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 165 | 165 |
ASIN |
4 |
Syntax:
ASIN(X)
Returns the arc sine of X, that i... |
MariaDB> SELECT ASIN(0.2);
-> 0.2013579207...
|
https://mariadb.com/kb/en/asin/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 166 | 166 |
SIGN |
4 |
Syntax:
SIGN(X)
Returns the sign of the argument ... |
MariaDB> SELECT SIGN(-32);
-> -1
MariaDB> ...
|
https://mariadb.com/kb/en/sign/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 174 | 174 |
% |
4 |
Syntax:
N % M, N MOD M
Modulo operation. Returns ... |
|
https://mariadb.com/kb/en/modulo-operator/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 196 | 196 |
CRC32 |
4 |
Syntax:
CRC32(expr)
Computes a cyclic redundancy ... |
MariaDB> SELECT CRC32('MySQL');
-> 3259397...
|
https://mariadb.com/kb/en/crc32/ |
| | 编辑 | 复制 | 删除 DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 207 | 207 |
LOG10 |
4 |
Syntax:
LOG10(X)
Returns the base-10 logarithm of... |
MariaDB> SELECT LOG10(2);
-> 0.30102999566...
|
https://mariadb.com/kb/en/log10/ |
