Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
When creating a table with the the VECTOR data type, you can provide the model to use in the ENGINE_ATTRIBUTE for either the column or table. If you are on a version earlier than MySQL 9.4.0, you must use CREATE TABLE and set ENGINE to lakehouse, ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-manage-aws-access.html
IDDetails: You need to specify the IDDetails in the trust policy when creating some of the IAM roles described in this chapter. Manage AWS Access 21.5 Manage AWS Access Use the AWS Management Console to manage AWS access. For ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-troubleshooting-query-privatelink.html
Table 6-1 Query PrivateLink: Common Issues and Resolutions Deployment Step Error Summary Steps to Resolve Create Query PrivateLink CreatePrivateLink: 1 Validation Error for … principalArn Ensure the ARNs you have entered are formatted properly.
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. What this means is that we can create a Java interface and only use the operations on this interface without any internal knowledge of what the ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. To ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. As a result, MERGE table collections are very fast to create or remap. (You must still ... MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...