Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value ...
https://dev.mysql.com/doc/refman/8.4/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...