Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/sql-crud-functions.html
Table.insert() The Table.insert() method works like an INSERT statement in SQL. myTable.insert(['id', 'name']).values(1, 'Imani').values(2, 'Adam').execute() Figure 6.1 Table.insert() Syntax Diagram Table.select() The Table.select() method works ...
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-debugging-queries.html
In this mode, a SELECT statement returns an error if it cannot be offloaded. The use_secondary_engine variable can be set as shown: Using a SET statement before running queries: mysql> SET SESSION use_secondary_engine = FORCED; Using a SET_VAR ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. SELECT statements are supported, but only the SELECT portion is offloaded to MySQL HeatWave. Define all tables accessed by the query ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Re-issue the statement every so often while a typical workload is running, until the predictions have stabilized. Leave Auto Shape Prediction running to monitor other workloads, or disable Auto Shape Prediction with this statement: mysql> CALL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-inbound-replication-limitations.html
Using a root@localhost or administrator user in the DEFINER clause of CREATE PROCEDURE and CREATE FUNCTION statements is not supported. Instead, create a dedicated user with the privileges required to run the statements, and then edit the statements ... Limitations 8.8 Limitations Inbound replication in MySQL HeatWave on AWS does not support some of the configurations that are possible for MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
This option applies only to prepared statements, callable statements or updatable result sets. This option applies only to prepared statements, callable statements or updatable result sets. connectionTimeZone Configures the connection time zone ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value random Since Version 5.0.6 loadBalanceAutoCommitStatementRegex When load-balancing is enabled for auto-commit statements (via 'loadBalanceAutoCommitStatementThreshold'), the statement counter will only increment when the SQL matches ...
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 ...