MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 66 total results

14.16.7.1 General Geometry Property Functions

https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html

The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value ...

14.16.7.3 LineString and MultiLineString Property Functions

https://dev.mysql.com/doc/refman/8.0/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. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...

14.16.7.2 Point Property Functions

https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html

A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...

14.16.7.4 Polygon and MultiPolygon Property Functions

https://dev.mysql.com/doc/refman/8.0/en/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 geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, ...

13.1 Numeric Data Types

https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html

These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). MySQL also treats REAL as a synonym for DOUBLE PRECISION (a nonstandard ...

14.16.3 Functions That Create Geometry Values from WKT Values

https://dev.mysql.com/doc/refman/8.0/en/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 ...

MySQL Glossary

https://dev.mysql.com/doc/refman/8.0/en/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 ...

28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html

1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. For related usage information and examples, see Section 17.15.3, “InnoDB ...

17.9.1.3 Tuning Compression for InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html

On the other hand, tables containing mostly binary data (integers or floating point numbers) or data that is previously compressed (for example JPEG or PNG images) may not generally compress well, significantly or at all. Most often, the internal ...

14.17.5 Functions That Return JSON Value Attributes

https://dev.mysql.com/doc/refman/8.0/en/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 ...

Displaying 51 to 60 of 66 total results