PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. pre-space The number of decimal columns that are stored with leading spaces. no endspace, not_always Do not ...When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if ...This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. BLOB and TEXT columns only ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Examples: ANALYZE TABLE fails because it updates table statistics, which are stored in the data dictionary. ALTER TABLE tbl_name ENGINE=engine_name fails because it updates the storage engine designation, which is stored in the data dictionary. Use ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
When retrieved, values stored into an ENUM column are displayed using the lettercase that was used in the column definition. If you store a number into an ENUM column, the number is treated as the index into the possible values, and the value stored ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Inverted indexes store a list of words, and for each word, a list of documents that the word appears in. To support proximity search, position information for each word is also stored, as a byte offset. mysql> SELECT index_id, name, table_id, space ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Variable-length types such as VARCHAR are stored using a fixed length. CREATE TABLE t (i INT) ENGINE = MEMORY; As indicated ...Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas or read-only caches for data pulled from other ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
These memory pages are managed as listed here: Fixed-size pages: These store the fixed-size parts of rows stored in a given fragment. Variable-sized pages: These store variable-sized parts for rows in the fragment. Hash index pages: These are ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is the total number of digits that can be stored. For example, ...