Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
To exclude a column, specify the NOT SECONDARY column attribute in an ALTER TABLE or CREATE TABLE statement, as shown below. mysql> ALTER TABLE tbl_name MODIFY column_name datatype NOT SECONDARY; mysql> CREATE TABLE tbl_name ( column_1 datatype, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. Auto Parallel Load automatically gets the schema of the CSV files and creates the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
The function definition must not contain CREATE, INSERT, ALTER, UPDATE, or DELETE statements. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the table is created on the MySQL Database Service instance. Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-0.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. This default value change impacts the following processes: New vector store tables are created using multilingual-e5-small by default. Retrieval augmented generation ...Important As of MySQL 9.3.0, to help you generate better quality embeddings, MySQL HeatWave GenAI uses multilingual-e5-small as the default embedding model for encoding documents in all supported languages including ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-5-1.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. (WL #17170) MySQL HeatWave Lakehouse now supports specifying stored generated columns when using the CREATE TABLE statement for Lakehouse tables. Using stored ...