Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/glossary.html
For example, for a column with a unique constraint, the number of different values is equal to the number of rows in the table. See Also column, composite index, index, index hint, persistent statistics, random dive, selectivity, unique constraint.
https://dev.mysql.com/doc/refman/8.4/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.4/en/information-schema-check-constraints-table.html
CREATE TABLE supports the core features of table and column CHECK constraints; the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: CONSTRAINT_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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/ndbapi/en/ndb-error-codes-single.html
Foreign key constraint violated: No parent row found 256 MySQL error. This section lists all NDB errors, ordered by NDB error code. Each listing also includes the error's NDB error type, the corresponding MySQL Server error, and the text of the ...