Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
TABLESPACE=innodb_file_per_table but is otherwise not supported for use in combination with the TABLESPACE clause. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv", "allow_missing_files": true}, "file": [{"uri": "oci://mybucket@mynamespace/data_files/data_file_[1-10].csv"}]}'; Refer to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv') VERIFY_KEY_CONSTRAINTS = 0; Refer to the following table to review how ... As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables. Review the following examples for different ways to create external tables. These ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
The update can use nested calls to any of the functions listed in the previous item, in any combination, as long as the input and target columns are the same. The next few paragraphs explain how each of these two functions handles the merging of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
It can be one of the following: page: for text segmentation based on the pagination available in the document. This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-diagnostics-report.html
If you intend to communicate with MySQL Enterprise Monitor support, it is strongly recommended you provide this report with your support request. Introduction To generate a diagnostic report file, select Diagnostics Report from the Help menu. The ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-session.html
sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET [SESSION] ..." to the server when the driver connects. Since Version 3.1.8 characterEncoding Instructs the server to set session system variables ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-session.html
sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET [SESSION] ..." to the server when the driver connects. Since Version 3.1.8 characterEncoding Instructs the server to set session system variables ...