Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. Error number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000 Message: Cannot delete or update a parent row: a foreign key ...Data source error: %s Error number: 1431; Symbol: ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST; SQLSTATE: HY000 Message: The foreign data source you are trying to reference does not ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Use the Model menu, Menu Options menu item to set a project-specific default name for the foreign key column (see Section 9.1.1.1.5.4, “The Relationship Notation Submenu”). To edit the properties of a foreign key, double-click anywhere on the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). FOR_NAME The name of the child table in this foreign key relationship.
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
child table In a foreign key relationship, a child table is one whose rows refer (or point) to rows in another table with an identical value for a specific column. The values in the child table can prevent delete or update operations on the parent ...MySQL can build a hash index on a prefix of any length of the key defined for the B-tree, depending on the pattern of searches against the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-cols-table.html
The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. The INNODB_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field; the same value as INNODB_FOREIGN.ID. POS The ...Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS WHERE ID = 'test/fk1'\G ...For related usage ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. If you use it, MySQL ignores ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Green Table name Shows all of the outgoing relationships (foreign keys) defined on the table in focus, which reference a different table (see Figure 9.11, “Green and Blue Highlight”). Blue Table name Shows all of the incoming relationships ...
https://dev.mysql.com/doc/refman/8.4/en/primary-key-optimization.html
These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. With the InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. A successful migration operation has this result: The destination keystore contains the keys it had prior to the ...