Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-remove.html
The Collection.remove() function is for removing documents in a collection, similar to the DELETE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be removed ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-unload.html
Unload Advisor recommends tables to unload, reducing MySQL HeatWave memory usage. The recommendations are based upon when the tables were last queried. Run Unload Advisor For Advisor to recommend tables to unload, the tables must be loaded in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. A temporary table is visible only within the current session, and is dropped automatically when you close the session. Once created, you can use a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.4 Error Message Reference for Lakehouse error messages. As of MySQL 9.2.2, a detailed summary of warnings is available when loading data to Lakehouse. This includes warnings related to the schema inference stage of loading data. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model handle. If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-queries.html
Running MySQL HeatWave Queries 10.1 Running MySQL HeatWave Queries When a MySQL HeatWave Cluster is enabled and the data you want to query is loaded in MySQL HeatWave, queries that qualify are automatically offloaded from the MySQL DB System to the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-client-side-failover-xdevapi.html
This is a sample X DevAPI URL for configuring client-side failover: mysqlx://sandy:mypassword@[host1:33060,host2:33061]/test With the client-side failover configured, when there is a failure to establish a connection, Connector/J keeps attempting to ... When using the X Protocol, Connector/J supports a client-side failover feature for establishing a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/refman/8.4/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...