Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-crud-operations.html
This section explains how to use the X DevAPI for Create Read, Update, and Delete (CRUD) operations. X DevAPI extends this domain by adding support for CRUD operations that can be run against collections of documents.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/fetching-all-data-items-at-once.html
The following example assumes that the test schema exists and that the employee table exists in myTable. myResult = myTable.select(['name', 'age']) \ .where('name like :name').bind('name','L%') \ .execute() myRows = myResult.fetch_all() for row in ... In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one by one, X DevAPI also provides a pattern using fetchAll(), which passes all data items of a data set as a list to the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. This section describes what a document ID is and how to work with it. The document ID value is usually automatically ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. res = mySession.sql('SELECT name, age FROM users').execute() row ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
The vector store tables created with MySQL HeatWave GenAI also persist in the block storage. MySQL HeatWave is a fully-managed cloud service that enables organizations to efficiently run analytics, transactional processing, machine learning, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
The mysql_tasks.config table stores the following key values that are used to define maximum task limits: The limits.maximumPreparedStmtAsyncTasks key specifies the maximum number of SQL statements that can run concurrently within the MySQL HeatWave ... As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
A query execution plan may have nodes for table scans, JOIN, GROUP BY and other operations. The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a ...