Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same region. This task requires the following: A client ...
https://dev.mysql.com/doc/connector-j/en/connector-j-source-replica-replication-connection.html
This section describe a number of features of Connector/J's support for replication-aware deployments. Such Connection objects report they are read-only, and isSourceConnection() returns false for them. The Connection tests for available source ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
For more information on MySQL stored procedures, please refer to Using Stored Routines. Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Section 11.2.1, “Identifier Length Limits”, indicates ...