Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to ...
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/refman/8.4/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...
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/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/heatwave-aws/en/heatwave-aws-hwaml-create-model.html
Create a MySQL HeatWave AutoML model 13.2 Create a MySQL HeatWave AutoML model Use the MySQL HeatWave Console to create a new MySQL HeatWave AutoML model. Create a MySQL HeatWave AutoML model includes an advanced option to choose one or more ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...