Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0.html
Functionality Added or Changed MySQL HeatWave Guided Load reduces the number of steps to manually load data, see Load Data Manually. (WL #15811) MySQL HeatWave now supports the following string functions: BIN() BIT_LENGTH() ELT() EXPORT_SET() ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same region. This task ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for evaluation. This optimization can be used only by the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...