Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-existing-collections.html
Therefore it is best to separate the code that creates the collections in the database from the actual user application code. # Get a collection object for 'my_collection' myColl = db.get_collection('my_collection') The createCollection(), together ... In order to retrieve a Collection object for an existing collection stored in the database call the getCollection() function from a Schema ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-resource-principal.html
Dynamic groups allow you to group DB Systems as principal actors, similar to user groups. You can then create policies to permit DB Systems in these groups to make API calls against services, such as Object Storage. Create a new dynamic group or ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Syntax Examples An example that exports a model to a table, switches users, and then imports the model from that table. Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
See Creating an IAM Policy to Access an Amazon S3 Bucket. See Creating an IAM Role to Access an Amazon S3 Bucket. Authentication method: Select either one of the following authentication methods by clicking its radio button: IAM role: Use the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
For example, utf8mb4_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8mb4 collations. In Japan, since the supplementary characters are obscure Kanji ideographs, the typical user does not care ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
The table can be accessed freely by the session within which it was created, regardless of what other locking may be in effect. The following statements are prohibited while a LOCK TABLES statement is in effect: CREATE TABLE, CREATE TABLE ... LIKE, ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
The namespace enables different applications to use the same lock names without colliding by creating locks in separate namespaces. This is distinct from, for example, locks acquired with the GET_LOCK() function, which have an OBJECT_TYPE of USER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. The user-supplied expression is evaluated each time a ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...It ... SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A user variable referenced by a statement in a stored procedure has its type ... A ...