Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-we-sets.html
ascii (US ASCII) collations: ascii_bin ascii_general_ci (default) cp850 (DOS West European) collations: cp850_bin cp850_general_ci (default) dec8 (DEC Western European) collations: dec8_bin dec8_swedish_ci (default) The dec character set is ...
https://dev.mysql.com/doc/refman/8.4/en/checking-rpm-signature.html
To import the MySQL public key into the RPM keyring, first obtain the key, then use rpm --import to import the key. For example: $> gpg --export -a a8d3785c > a8d3785c.asc $> rpm --import a8d3785c.asc Alternatively, rpm also supports loading the key ...RPM 4.1 no longer uses your personal GPG keyring (or GPG ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. The following list names the functions in MySQL 8.4 that are affected by the IGNORE_SPACE setting and listed as special in the sql/lex.h source file. ADDDATE ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
Each member makes its own decision locally, following the primary election algorithm in its MySQL Server release. Because all members must reach the same decision, members adapt their primary election algorithm if other group members are running ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%'; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host address. Start the MySQL server with an appropriate bind_address setting to permit it to accept ...