Search Results
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
If the table already has a primary key on some longer column, such as a VARCHAR, consider adding a new unsigned AUTO_INCREMENT column and switching the primary key to that, even if that column is not referenced in queries. If you have MyISAM tables ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
Nongenerated and generated columns are permitted, except columns with the AUTO_INCREMENT attribute and columns in other tables. CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
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 table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
However, MySQL has an AUTO_INCREMENT system, which can also handle inserts in a multi-source replication setup. With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values ...Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? ...