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/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/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. (That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it ...
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/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/cast-functions.html
Examples: For conversion of a “zero” date string to a date, CONVERT() and CAST() return NULL and produce a warning when the NO_ZERO_DATE SQL mode is enabled. Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a ...
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/gis-polygon-property-functions.html
If the argument is NULL or an empty geometry, the return value is NULL. Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid computation. If the argument is an empty geometry collection, the ... Functions in this section return properties of Polygon or MultiPolygon ...
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 ...