Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
You create an external table and set empty strings for both the escape character and quotation character: "dialect": {"quotation_marks": "", "escape_character": ""}. If has_header and skip_rows are both specified, Lakehouse first skips the number of ... External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prepare.html
To prepare the data for this use case, you set up a dataset to use for both training and testing. mysql> CREATE DATABASE topic_modeling_data; mysql> USE topic_modeling_data; Create the table to use for both training and testing. As he learns more ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
The reason for this is as follows: During both server-side prepared statements and client-side emulation, large data is exchanged only when PreparedStatement.execute() is called. Both require a separate connection to issue the KILL QUERY statement.
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Both options take a comma-separated list of one or more partition names. TABLESPACE on subpartitioned tables, both partition and subpartition names are allowed. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Binary log transaction compression therefore saves storage space both on the originator of the transaction and on the recipient (and for their backups), and saves network bandwidth when the transactions are sent between server instances. Setting ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. Program options specified on the command line follow these rules: Options ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
This operator performs an equality comparison like the = operator, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL. Table 14.4 Comparison Operators Name Description > Greater than operator >= ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
Note It is possible to install one plugin without the other, but both must be installed for full connection control capability. The connection_control_min_connection_delay and connection_control_max_connection_delay system variables both have ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
It specifies that the event executes one time only at the date and time given by timestamp, which must include both the date and time, or must be an expression that resolves to a datetime value. You may use STARTS, ENDS, both, or neither in an EVERY ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
The DATETIME type is used for values that contain both date and time parts. The TIMESTAMP data type is used for values that contain both date and time parts. This occurs because the same time zone was not used for conversion in both directions. This ...