Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. In most respects, account names are similar to MySQL role names, with some ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The examples given here show what the setting might ...To change these defaults, use the --character-set-server and --collation-server options when you start the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
MySQL supports these Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per character. Note utf8 is expected in a future version of MySQL to become an alias for utf8mb4. Note The utf8mb3 character ... The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. Download and install Gpg4win, load Kleopatra, and add the MySQL Release Engineering certificate. Type "Mysql Release Engineering" ...That guide also applies to Microsoft Windows, but another option is to use a GUI tool like ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
REDUNDANT Row Format COMPACT Row Format DYNAMIC Row Format COMPRESSED Row Format Defining the Row Format of a Table Determining the Row Format of a Table REDUNDANT Row Format The REDUNDANT format provides compatibility with older versions of MySQL.
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
Restoring Orphan File-Per-Table ibd Files This procedure describes how to restore orphan file-per-table .ibd files to another MySQL instance. You might use this procedure if the system tablespace is lost or unrecoverable and you want to restore .ibd ... Information about table definitions is stored in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... The syntax of table_factor is ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
| TABLE | VALUES order_by_clause: ORDER BY as for SELECT limit_clause: LIMIT as for SELECT into_clause: INTO as for SELECT set_op: UNION | INTERSECT | EXCEPT MySQL 8.4 supports parenthesized query expressions according to the preceding syntax.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...