PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
A foreign key constraint on a stored generated column cannot use CASCADE, SET NULL, or SET DEFAULT as ON UPDATE referential actions, nor can it use SET NULL or SET DEFAULT as ON DELETE referential actions. A foreign key constraint on the base column ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
As of MySQL 8.0.27, these additional privilege considerations apply: The authentication_policy system variable places certain constraints on how the authentication-related clauses of CREATE USER statements may be used; for details, see the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Does NDB Cluster support foreign keys? NDB Cluster provides support for foreign key constraints which is comparable to that found in the InnoDB storage engine; see Section 1.6.3.2, “FOREIGN KEY Constraints”, for more detailed information, as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Multi-primary mode groups (members all configured with group_replication_single_primary_mode=OFF) do not support tables with multi-level foreign key dependencies, specifically tables that have defined CASCADING foreign key constraints. This is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction. The ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. These privileges enable users to perform certain restricted multifactor authentication-related operations: A user who has the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 8.0 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. (Bug ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb_deferred_constraints: Specifies that constraint checks should be deferred (where these are supported).
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
You should use this option prior to inserting new rows into the database; otherwise, it is possible for a row to be inserted that later causes a unique constraint violation when trying to rebuild the indexes. The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
This facilitates higher rates of update operations for each node group in the cluster, and helps avoid constraints imposed by system or other limitations on inter-node communications using a single socket. This situation could arise when constraint ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...