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/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/refman/8.4/en/grant.html
Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege characteristics such as its password, whether it uses secure connections, and limits on access to server resources, then uses GRANT to define ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-creating-user-roles-tasks.html
Creating a Role Note It is not possible to save a new user without an assigned role. To create a role, do the following: Select Roles from the Settings menu (gear icon). Creating a User This section describes how to create a user. To create a user, ...On the Details tab, enter a name in the Role Name field and add a description of the ...
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/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
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 ...