Search Results
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations on JSON values to ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
This means that, for example, the following CREATE TABLE statement is rejected with an error: mysql> CREATE TABLE t ( -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, -> cf FLOAT DEFAULT (RAND() * 10) -> ) ENGINE=NDBCLUSTER; ERROR 3774 (HY000): ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-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 ...