Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...Row Formats The row format of an InnoDB table determines how its rows are physically stored on ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-iam-role-cloudwatch.html
Creating an IAM Role and Policy for CloudWatch Monitoring 21.5.5 Creating an IAM Role and Policy for CloudWatch Monitoring Use the AWS Management Console to create an IAM role for using CloudWatch to monitor your DB Systems and MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...
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/heatwave/en/mys-hw-lakehouse-generated-columns.html
As of MySQL 9.5.1, you have the option to include stored generated columns when creating external Lakehouse tables. To learn more about generated columns, see CREATE TABLE and Generated Columns. Before You Begin Prepare to create external tables by ...col_name data_type [GENERATED ALWAYS] AS (expr) STORED [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'], ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Review the following examples to see the different ways to use resource principals to specify files when creating external tables manually. Resource Principals Examples The following examples use these parameters to create the external tables and ...This topic contains the following sections: Before You Begin Resource Principals Parameters Resource Principals Examples Specify a Single File Specify Multiple Files for One External Table Specify Files with a Pattern What's Next Before You Begin Review the requirements to Access Object Storage with Resource ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave AutoML. Prepare Datasets Create and use the the database ml_data to store the table of data. mysql> CREATE SCHEMA ...It ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Applications are able to authenticate using a provided user name and password, or using a locally cached TGT or ST (for example, created using kinit or similar). The output should be similar to this: $> klist Ticket cache: FILE:/tmp/krb5cc_244306 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables. Review the following examples for different ways to create external tables. These ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...