Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-enterprise-audit.html
MySQL Enterprise Audit 3.1.2.7 MySQL Enterprise Audit MySQL HeatWave on AWS supports the MySQL Enterprise Audit plugin for MySQL Server 8.1.0 and later. The audit plugin enables the MySQL Server to produce a log file containing an audit record of ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
You can select the JSON tab to view results in JSON format. Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave queries. To run a query using the Query ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/refman/8.4/en/audit-api-message-emit.html
For example, the audit_log plugin (see Section 8.4.5, “MySQL Enterprise Audit”) logs message values as follows, depending on the log format configured by the audit_log_format system variable: JSON format (audit_log_format=JSON): { ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
This can be useful for working with columns of types that cannot be indexed directly, such as JSON columns; see Indexing a Generated Column to Provide a JSON Column Index, for a detailed example. Values of a generated column are computed from an ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The value assigned to this option must be a string literal containing a valid JSON document or an empty string (''). The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...
https://dev.mysql.com/doc/refman/8.4/en/displaying-traces.html
As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON. Examining a trace in the mysql command-line client can be made less difficult using the pager less ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total; this includes JSON columns. See String Type Storage Requirements, as well as JSON Storage Requirements, for more information relating to these types. Some database objects such ...