PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
| [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... For general background in addition to the following descriptions, see Section 13.1.14, “CREATE INDEX Statement”, and Section 13.1.18.5, ...| ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
| ADD [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... Foreign Keys and Other Constraints The FOREIGN KEY and REFERENCES clauses are supported by the InnoDB and NDB storage engines, which ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. If the constraint is a foreign key, then ...TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
You can also rename a column that is part of a foreign key constraint. 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 ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/server-system-variables.html
foreign_key_checks System Variable foreign_key_checks Scope Global, Session Dynamic Yes Type Boolean Default Value ON If set to 1 (the default), foreign key constraints are checked. If set to 0, foreign key constraints are ignored, with a couple of ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/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 constraint names consist of the table name plus _ibfk_ and a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Hash indexes are always used for primary key indexes, unique indexes, and unique constraints. The unique constraint is implemented by a separate table with b as primary key and a as a column. Thus, for one million records, we need 58MB for index ...
https://dev.mysql.com/doc/refman/5.7/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 Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 Controls whether or not ... This ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...