Search Results
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. In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume ...
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/parameter-binding.html
The example assumes that the test schema has been assigned to the variable db and that the collection my_collection exists. The example assumes that the test schema has been assigned to the variable db and that the collection my_collection exists.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
The example assumes that the test schema exists and that the collection my_collection does not exist. Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-collections-basic-crud.html
The example assumes that the test schema exists and that the collection my_collection does not exist. Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
It is assumed that the test schema exists and is assigned to the variable db, that the collection my_collection exists and that custom_id is unique. This section describes what a document ID is and how to work with it. Every document has a unique ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
Consistent reads ignore any locks set on the records that exist in the read view. Locks are held for as long as the transaction which they were acquired in exists. X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
For example, consider the following statements with no explicit BEGIN, session.startTransaction() or similar call: session.setSavepoint('testsavepoint'); session.releaseSavepoint('testsavepoint'); If autocommit mode is enabled on the server, these ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
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-auto-unload.html
Overview for Unloading Data Automatically Unloading a table from MySQL HeatWave may be necessary to replace an existing table, to reload a table, to free up memory, or simply to remove a table that is no longer used. You can use MySQL HeatWave Auto ...