Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-collections-basic-crud.html
The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: After establishing a connection to a MySQL Server instance, a new collection that ... Working with collections of documents is straightforward when using X ...
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Lakehouse and Tracking/Monitoring Privileges You need the following privileges to access external Lakehouse tables that have machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. However, if the SELECT query returns a large result set, queries that produce large result sets performance may be limited because inserting the data into the DB ...When the query is offloaded to MySQL HeatWave, it is processed faster, improving the overall performance of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object Storage. You need to first ingest these documents into vector store tables using Auto Parallel Load. The generated table contains ...
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-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/en/mys-hwaml-error-messages.html
Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Each error message includes an error number, SQLSTATE value, and ...