Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
LIKE: Foreign key definitions are ignored, as are the DATA DIRECTORY and INDEX DIRECTORY table options. (Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
For example, a duplicate key was inserted or a foreign key constraint would fail. The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
For example, a duplicate key was inserted or a foreign key constraint would fail. The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
For versions earlier than MySQL 9.4.0, tables must have a primary key, and the primary key must not have a prefix index. MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK. MySQL HeatWave on AWS does support LOAD DATA with ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
model_handle A primary key, and a foreign key that references model_handle in the MODEL_CATALOG table. The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction. When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
Gap locking is only used for foreign-key constraint checking and duplicate-key checking. For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. The related system variable binlog_rotate_encryption_master_key_at_startup, which rotates the binary log master key automatically when the server ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
In certain rare cases, a CREATE TABLE statement involving the creation of a table with foreign keys was not processed correctly. As part of this fix, primary keys were added to DATA_LOCKS and DATA_LOCK_WAITS. (Bug #36522343) InnoDB: The upgrade ...