https://dev.mysql.com/gis-polygon-property-functions.html
Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this section handle their arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the ...
https://dev.mysql.com/gis-wkb-functions.html
These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). For a description of WKB format, see Well-Known Binary (WKB) Format. Functions in this ...
https://dev.mysql.com/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). For a description of WKT format, see Well-Known Text (WKT) Format. Functions in this section detect arguments in ...
https://dev.mysql.com/glossary.html
(Thus it is similar to the IEEE floating-point concept of NaN, “not a number”.) Any aggregate calculation such as AVG() ignores rows with NULL values, when determining how many rows to divide by. These terms are commonly used in information ...
https://dev.mysql.com/group-by-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). This section describes group (aggregate) functions that operate on sets of ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. The examples in this section use the ...
https://dev.mysql.com/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. MySQL provides support ...
https://dev.mysql.com/problems-with-null.html
If you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that ...
