Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-retrieve-schema-metadata.html
Retrieves the most relevant tables to a given natural-language statement and ranks them in the order of their relevance. The output generated by the routine can be used to enhance large language model (LLM) prompts, NL_SQL workflows, and ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-0.html
The primary and secondary engines for MySQL HeatWave Lakehouse tables are now determined by session variables, eliminating the need to specify engines explicitly. This enhancement also lets you specify the primary engine for MySQL HeatWave temporary ... Note MySQL HeatWave User Guide has been restructured and improved to provide better visibility of high-level ...
https://dev.mysql.com/doc/refman/9.7/en/correlated-subqueries.html
The optimizer can transform a correlated scalar subquery to a derived table when the subquery_to_derived flag of the optimizer_switch variable is enabled. The subquery may contain LIMIT 1 but no other LIMIT clause; it must use a literal 1, and no ...
https://dev.mysql.com/doc/refman/9.7/en/declare-cursor.html
The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. Cursor declarations must appear before handler declarations and after variable and condition declarations. DECLARE ...
https://dev.mysql.com/doc/refman/9.7/en/fetch.html
If a row exists, the fetched columns are stored in the named variables. The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. This statement fetches the next row for the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-collections.html
In this quick-start guide: Basic objects include: Object form Description db db is a global variable assigned to the current active schema. When you want to run operations against the schema, for example to retrieve a collection, you use methods ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-relational-tables.html
Confirm the Schema To show the schema that is assigned to the db global variable, issue db. mysql-js> db <Schema:world_x> If the returned value is not Schema:world_x, set the db variable as follows: mysql-js> \use world_x Schema `world_x` accessible ... You can also use X DevAPI to work with relational ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-collections.html
In this quick-start guide: Basic objects include: Object form Description db db is a global variable assigned to the current active schema. When you want to run operations against the schema, for example to retrieve a collection, you use methods ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-relational-tables.html
Confirm the Schema To show the schema that is assigned to the db global variable, issue db. mysql-py> db <Schema:world_x> If the returned value is not Schema:world_x, set the db variable as follows: mysql-py> \use world_x Schema `world_x` accessible ... You can also use X DevAPI to work with relational ...