PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns the arc sine of X, ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( ...
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. (There is an existing SQL function Length() that calculates the length of string values.) GLength() is deprecated; expect it to be ...EndPoint() is deprecated; expect it to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
The name of this table is that of the table for which conflict resolution is to be applied, with the string $EX appended. (An example that uses NDB$OLD() with an exceptions table is shown later in this section.) Additional columns may optionally be ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
LineFromText(wkt [, srid]), LineStringFromText(wkt [, srid]) ST_LineFromText(), ST_LineStringFromText(), LineFromText(), and LineStringFromText() are synonyms. LineFromText() and LineStringFromText() are deprecated; expect them to be removed in a ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
ST_Buffer(g, d [, strategy1 [, strategy2 [, strategy3]]]) Returns a geometry that represents all points whose distance from the geometry value g is less than or equal to a distance of d, or NULL if any argument is NULL. An ER_WRONG_ARGUMENTS error ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses. The ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Return value: If the call succeeds, the return value is a binary JSON string containing an array of audit events, or a JSON null value if that was ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
mysql> SET @ls1 = ST_GeomFromText('LINESTRING(0 0)'); mysql> SET @ls2 = ST_GeomFromText('LINESTRING(0 0, 1 1)'); mysql> SELECT ST_AsText(ST_Validate(@ls1)); +------------------------------+ | ST_AsText(ST_Validate(@ls1)) | ...ST_Distance_Sphere(g1, ... The functions in this section provide convenience operations on geometry ...