Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the source. Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, ...
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/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
Review the following examples to see the different ways to use resource principals and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external table and the ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
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/8.4/en/create-role.html
CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. When the read_only system ...If ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
If you create the dump files on your local system, you need to transfer them to the Oracle Cloud Infrastructure Compute instance using the copy utility of your choice, depending on the operating system you chose for your Compute instance. The dumps ... MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket or a set of local ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). NDB Cluster stores foreign key names using the same lettercase with which they are created. Creating a foreign key constraint requires ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. This setting has no effect on tables created using any other storage engine than InnoDB. row *************************** ...