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/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
If you use a multiple-table DELETE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. DELETE is a DML ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME: Strings that indicate the catalog, schema, and name for a violated constraint. SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Group profile names are chosen by the firewall administrator with no constraints other than that their length must be from 1 to 288 characters. Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
Constraints on full-text searching are listed in Section 14.9.5, “Full-Text Restrictions”. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
If a transaction executes against a table that has foreign keys with cascading constraints, then its commit fails when synchronizing itself with the group. In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. This section lists the system variables that are specific to the Group ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. In MySQL, databases correspond to directories within the data directory. Each table ...
https://dev.mysql.com/doc/refman/8.0/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 ...