Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-metadata.html
Results contain metadata related to the origin and types of results from relational queries. This metadata can be used by applications that need to deal with dynamic query results or format results for transformation or display. An array of columns ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ON. Check if you ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. schema_name (VARCHAR(255)): specifies the schema to run the given SQL statements. If the schema is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-list.html
The task_list routine returns a paginated list of asynchronous tasks. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_list( IN 'task_type' VARCHAR(80), IN offset INT UNSIGNED, IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... Yes Check whether a value is within a range of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading data, ensure that you meet the following requirements: The tables you intend to load must be set to ENGINE=InnoDB tables. You can manually ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-supported-models.html
This topic provides the list of languages that MySQL HeatWave GenAI supports and the embedding models as well as large language models (LLMs) that are available in MySQL HeatWave. This topic contains the following sections: Before You Begin View ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external ...