Search Results
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
The maximum number of indexes per table and the maximum index length is defined per storage engine. All storage engines support at least 16 indexes per table and a total index length of at least 256 bytes. For example: CREATE TABLE test (blob_col ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant Tables”. Note Direct modification of grant tables using statements such as INSERT, ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...For ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop ...This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
For InnoDB tables, minimum token size is defined by the innodb_ft_min_token_size configuration option, which has a default value of 3. For MyISAM tables, minimum token size is defined by ft_min_word_len, which has a default value of 4. Creating a ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. The following function ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...You ...