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/example-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. This following example relates parent and child tables through a single-column foreign ...A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
ALTER TABLE tbl1 ADD CONSTRAINT fk_name FOREIGN KEY index (col1) REFERENCES tbl2(col2) referential_actions; Dropping a foreign key constraint ALTER TABLE tbl DROP FOREIGN KEY fk_name; Dropping a foreign key can be performed online with the ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
Note Although the authentication_policy system variable places certain constraints on the authentication-related clauses of CREATE USER and ALTER USER statements, a user who has the AUTHENTICATION_POLICY_ADMIN privilege is not subject to the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
This places constraints on how the authentication-related clauses of CREATE USER and ALTER USER statements may be used. When using JSON_SCHEMA_VALID() to specify a CHECK constraint, MySQL 8.0.19 and later provides precise information about the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally generated foreign key and CHECK constraint names consist of the table name plus _ibfk_ ... The following table describes the maximum length for each type of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-deferred-constraints=[0|1] Command-Line Format --ndb-deferred-constraints System Variable ndb_deferred_constraints Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 Controls ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
There must be no tables that have foreign key constraint names longer than 64 characters. Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...