Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_FOREIGN_KEY_CHECKS Whether foreign key checks are turned on or off for the current transaction. TRX_LAST_FOREIGN_KEY_ERROR The detailed error message for the last foreign key error, if any; otherwise NULL. The INNODB_TRX table provides ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. A foreign key constraint between two columns in the same table, however, is permitted. To ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
As of yet, there are no INFORMATION_SCHEMA tables that correspond exactly to mysql.foreign_keys, mysql.foreign_key_column_usage. The standard SQL way to obtain foreign key information is by using the INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS and ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
The format of the CREATE SERVER statement is: CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) The server_name is used in the connection string when creating a new FEDERATED table. If you are creating a ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
ndb_show_foreign_key_mock_tables Command-Line Format --ndb-show-foreign-key-mock-tables[={OFF|ON}] System Variable ndb_show_foreign_key_mock_tables Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Show the mock tables ...--ndb-distribution=[KEYHASH|LINHASH] Command-Line Format --ndb-distribution={KEYHASH|LINHASH} System Variable ndb_distribution Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value KEYHASH Valid Values LINHASHKEYHASH Controls the default distribution method for NDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If a FOREIGN KEY constraint is defined on a table, any insert, update, or delete that requires the constraint condition to be checked sets shared record-level locks on the records that it looks at to check the constraint. The locks are normally ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
This option also drops any foreign keys specified in the backup. --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows the ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Strict mode does not affect whether foreign key constraints are checked. Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention ...