MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 67 total results

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.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 ...

14.17.3 Functions That Search JSON Values

https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html

type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR (MySQL 8.0.22 and later) YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/8.0/en/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. Some keywords which are otherwise ...

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 ...

18.2 The MyISAM Storage Engine

https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html

The only requirements for binary portability are that the machine uses two's-complement signed integers and IEEE floating-point format. MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table ...

26.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html

(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...

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 ...

22.3.3 Documents and Collections

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

22.4.3 Documents and Collections

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-collections.html

Displaying 51 to 60 of 67 total results