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/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. In an SQL statement that inserts, deletes, or updates many rows, foreign key ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html
The TABLE_CONSTRAINTS 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. ENFORCED For CHECK constraints, the value ...TABLE_SCHEMA The name of the schema (database) to which the table ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
| [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... Indexes, Foreign Keys, and CHECK Constraints Several keywords apply to creation of indexes, foreign keys, and CHECK constraints. For general ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html
As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, and the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/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 ...This table provides no information about functional key parts because they are expressions and the table provides information only about ...
https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html
row *************************** Level: Error Code: 3819 Message: Check constraint 'geo_chk_1' is violated. As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Incompatible change: In MySQL 5.7, specifying a FOREIGN KEY definition for an InnoDB table without a CONSTRAINT symbol clause, or specifying the CONSTRAINT keyword without a symbol, causes InnoDB to use a generated constraint name. Because ...