Search Results
https://dev.mysql.com/doc/internals/en/myisam-key-cache.html
...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Create foreign key failed - parent key is primary key and on-update-cascade is not allowed 21020 MySQL error. Create foreign key failed in NDB - no more object records 21021 MySQL error. Create foreign key failed in NDB - invalid request 21022 MySQL ...Query aborted due to invalid tree parameter specification: Key parameter bits mismatch 20013 MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
Foreign Keys and Other Constraints The FOREIGN KEY and REFERENCES clauses are supported by the InnoDB and NDB storage engines, which implement ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (...) REFERENCES ... For ALTER TABLE, unlike CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
Indexes, Foreign Keys, and CHECK Constraints Several keywords apply to creation of indexes, foreign keys, and CHECK constraints. For general background in addition to the following descriptions, see Section 15.1.15, “CREATE INDEX Statement”, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-foreignkey.html
This section provides information about the ForeignKey class, which models a foreign key on an NDB table. ForeignKey Class Overview ForeignKey() ForeignKey::FkAction ForeignKey::getName() ForeignKey::getParentTable() ForeignKey::getChildTable() ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references. For foreign-key constraints, this column is the ordinal position in key of the table that is being referenced. This table ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
INNODB_FOREIGN_COLS provides metadata about the columns of foreign keys that are defined on InnoDB tables. The MODIFIED_COUNTER value shows the number of rows modified by DML operations and cascade operations from foreign keys. Example 17.3 Foreign ...InnoDB INFORMATION_SCHEMA schema object tables include the tables listed here: INNODB_DATAFILES INNODB_TABLESTATS INNODB_FOREIGN INNODB_COLUMNS INNODB_INDEXES INNODB_FIELDS INNODB_TABLESPACES INNODB_TABLESPACES_BRIEF INNODB_FOREIGN_COLS INNODB_TABLES The table names are indicative of the type of data provided: INNODB_TABLES provides metadata about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...For ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. Note An easier alternative to generating the files required for SSL than the procedure described here is to let the ...The first example shows a simplified procedure such as you might use from the command ...