Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-modify.html
Notice that if DocPath points to a scalar or a document value, that value is autowrapped within an array and the value represented by ExprOrLiteral is added to that array. The modify(SearchConditionStr) function is for modifying documents in a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert to. By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
MySQL also supports ', 'a wide range of data types, including integers, floating-point numbers, dates, and strings. The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
Each point in a vector store represents the vector embedding of the corresponding data. This section describes the Vector Store functionality available in MySQL HeatWave. About Vector Store MySQL HeatWave vector store is a relational database that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_VALUE() Extract value from JSON document at location pointed to by path provided; return this value as VARCHAR(512) or specified type. Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
Lakehouse Engine The lakehouse storage engine allows you to create tables that point to external data sources. The Lakehouse feature of MySQL HeatWave enables query processing on data in Object Storage. MySQL HeatWave Lakehouse reads the source ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Note the following points about the ENGINE_ATTRIBUTE option: Ensure that the ENGINE_ATTRIBUTE option specifies all the files to be loaded. Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
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 Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
As of MySQL 9.4.0, you can set external table options using SQL syntax. The following options apply to CREATE TABLE and ALTER TABLE statements. For ALTER TABLE statements, ADD COLUMN is not supported for external tables. This topic contains the ...