Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given name. To ...An error occurs if the database exists and you did not specify IF NOT ...
https://dev.mysql.com/doc/heatwave-aws/en/creating-iam-role-genai.html
Creating an IAM Role to Access Amazon Bedrock LLMs 21.5.4 Creating an IAM Role to Access Amazon Bedrock LLMs Use the AWS Management Console to create an IAM role for MySQL HeatWave GenAI to access Amazon Bedrock LLMs. Do the following to create an ...If you want to grant access to a specific DB System, the resource ID of the DB ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-certs.html
create certs [--ca|--keys] [--added] cluster_name The command creates all certificate authorities (CAs), keys, and certificate files needed for a cluster to use TLS connections on all hosts in the site. The --ca option limits the command to only ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-plugins-create.html
MySQL Shell plugins can be used to contain functions that are registered as MySQL Shell reports (see Section 11.1, “Reporting with MySQL Shell”), and functions that are members of extension objects that are made available by user-defined MySQL ...A single plugin can contain and register more than one function, and can contain a mix of reports and members of extension ...
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-a-collection.html
In order to create a new collection call the createCollection() function from a Schema object. It returns a Collection object that can be used right away to, for example, insert documents into the database. Optionally, for Connectors, the field ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse table. After the data mapping is created, it allows the ...Once the S3 data is provided, the schema for the Lakehouse table is inferred automatically by MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html
Note When using MySQL Configurator to configure MySQL Server, it creates the my.ini at the default location, and the user executing MySQL Configurator is granted full permissions to this new my.ini file. In other words, be sure that the MySQL Server ... If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-query.html
Creating a Query PrivateLink 6.1.1 Creating a Query PrivateLink Use the MySQL HeatWave Console to create a Query PrivateLink to provide connectivity for applications running in your AWS account to MySQL HeatWave on AWS DB Systems using private IP ...This task requires the following: A DB System in the Active ...
https://dev.mysql.com/doc/refman/9.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...For ...
https://dev.mysql.com/doc/refman/9.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...A B-tree index on spatial values is useful for exact-value lookups, but not for range ...