PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log files. (This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON ...The audit log plugin determines the keyring ID of the decryption password as follows: If .enc is preceded by pwd_id, the keyring ID is ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
This works for an UPDATE statement which modifies a JSON column using any sequence of JSON_SET(), JSON_REPLACE(), and JSON_REMOVE(). To unset binlog_row_value_options and revert to writing the full JSON document, set its value to the empty string.
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
For instructions specific to the JSON and system log sinks, see Section 7.4.2.7, “Error Logging in JSON Format”, and Section 7.4.2.8, “Error Logging to the System Log”. The following example configures the use of the JSON log sink ... In ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. MySQL also supports a native JSON data type and a set of SQL functions to enable operations on JSON values. For more information, see Section 13.5, “The ...Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
Indexing a Generated Column to Provide a JSON Column Index As noted elsewhere, JSON columns cannot be indexed directly. In MySQL 8.0.21 and later, it is also possible to create an index on a JSON column using the JSON_VALUE() function with an ...A ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
Prior to MySQL 8.0.13, DEFAULT does not apply to the BLOB, TEXT, GEOMETRY, and JSON types. You can work around this restriction by creating an index on a generated column that extracts a scalar value from the JSON column. See Indexing a Generated ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
The first level of comparison is based on the JSON types of the compared values. If the two values have the same JSON type, a second level of comparison occurs using type-specific rules. For comparison of JSON and non-JSON values, the non-JSON value ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
JSON_ARRAYAGG(col_or_expr) [over_clause] Aggregates a result set as a single JSON array whose elements consist of the rows. If col_or_expr is NULL, the function returns an array of JSON [null] elements. In keeping with the MySQL JSON data type ...