PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/json.html
MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin collation. Strings in other character sets are converted to utf8mb4 as necessary. (For strings in the ascii or utf8mb3 character sets, no conversion is needed ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
However, by default, no whitespace is permitted in function invocations between the function name and the following ( character. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
In some cases, differing PACK_KEYS table option values among the MERGE and underlying tables cause unexpected results if the underlying tables contain CHAR or BINARY columns. The following are known problems with MERGE tables: MERGE child tables ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
$> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event data. A mutex is a synchronization mechanism used in the code to enforce that only one ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM tables have the following characteristics: All data values are stored with the low byte first. MyISAM also supports the following features: Support for a true VARCHAR type; a VARCHAR column starts with a length stored in one or two bytes.
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
This is often the case when you have large key values for CHAR, VARCHAR, or TEXT columns, because the sort operation needs to store the complete key values as it proceeds. The options described in this section can be used for any type of table ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
varchar prefix 0 1024 87 80 varchar 0 3 168 3 multip. uint24 NULL 0 1024 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 4 no zeros 3 6 81 varchar 4 87 81 varchar 5 168 3 1 1 no zeros 6 171 3 1 2 no zeros Explanations for the types of information ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-storage-requirements.html
For example, converting a CHAR(4) column from memory-based to disk-based format increases the amount of DataMemory used per row from 4 to 8 bytes. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
For memory-based columns, you can work around this limitation by using a variable-width column type such as VARCHAR or defining the column as COLUMN_FORMAT=DYNAMIC; this does not work with columns stored on disk. Some database objects such as ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
For example, applications can use the LPAD() function to zero-pad numbers up to the desired width, or they can store the formatted numbers in CHAR columns. MySQL supports an extension for optionally specifying the display width of integer data ...