Search Results
https://dev.mysql.com/doc/refman/9.7/en/internal-functions.html
CAN_ACCESS_COLUMN(ARGS) CAN_ACCESS_DATABASE(ARGS) CAN_ACCESS_TABLE(ARGS) CAN_ACCESS_USER(ARGS) CAN_ACCESS_VIEW(ARGS) GET_DD_COLUMN_PRIVILEGES(ARGS) GET_DD_CREATE_OPTIONS(ARGS) GET_DD_INDEX_SUB_PART_LENGTH(ARGS) INTERNAL_AUTO_INCREMENT(ARGS) ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-limitations.html
The following limitations or restrictions apply to all data modification operations (INSERT, UPDATE, and DELETE statements) on JSON duality views: Multiple INSERT, UPDATE, and DELETE operations on a JSON document is not supported. Data modification ...
https://dev.mysql.com/doc/refman/9.7/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views.html
With JSON duality views, you can establish a mapping between relational tables and a hierarchical multi-level JSON document, effectively unifying structured (relational) and semi-structured (JSON) data. Also known as JSON relational duality views, ...
https://dev.mysql.com/doc/refman/9.7/en/key-cache-block-size.html
To control the size of blocks in the .MYI index file of MyISAM tables, use the --myisam-block-size option at server startup. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. This permits tuning of the performance of I/O operations for index ...
https://dev.mysql.com/doc/refman/9.7/en/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-plugin.html
This is simpler and has no side effects, but is not suitable for installations that require minimal server downtime with as few restarts as possible. Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-encrypted-file-component.html
Verify component installation by examining the Performance Schema keyring_component_status table: mysql> SELECT * FROM performance_schema.keyring_component_status; A Component_status value of Active indicates that the component initialized ... Note ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-file-component.html
Verify component installation by examining the Performance Schema keyring_component_status table: mysql> SELECT * FROM performance_schema.keyring_component_status; A Component_status value of Active indicates that the component initialized ... The ...
https://dev.mysql.com/doc/refman/9.7/en/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...