Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
Can I run NDB Cluster nodes inside virtual machines (such as those created by VMWare, VirtualBox, Parallels, or Xen)? A.10.13. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an ... In ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
Instructions for creating any required certificate and key files are available in Section 8.3.3, “Creating SSL and RSA Certificates and Keys”. Should you need to create the required certificate and key files, see Section 8.3.3, “Creating SSL ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
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/refman/8.4/en/load-data.html
The server creates a copy of the file in the directory where it stores temporary files. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/heatwave-aws/en/creating-iam-policy-genai.html
Creating an IAM Policy to Access Amazon Bedrock LLMs 21.5.3 Creating an IAM Policy to Access Amazon Bedrock LLMs Use the AWS Management Console to create an IAM policy for MySQL HeatWave GenAI to access Amazon Bedrock LLMs. Do the following to ...
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-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...