PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
Beginning with MySQL 8.0.30, MySQL provides collations for both major varieties of Norwegian: for Bokmål, you can use utf8mb4_nb_0900_ai_ci and utf8mb4_nb_0900_as_cs; for Nynorsk, MySQL now provides utf8mb4_nn_0900_ai_ci and utf8mb4_nn_0900_as_cs.
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
STR_TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts. This works if the option is used on both the replication source server and the ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
This example works with both the component function and the legacy function: SET @priv1 = create_asymmetric_priv_key('RSA', 2048); SELECT create_asymmetric_priv_key('RSA', 2048) INTO @priv2; INSERT INTO t (key_col) ... To use MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
On other platforms, both the server and client plugins are supported. On other platforms, both the server and client plugins are supported. LDAP authentication using Kerberos requires both a KDC server and an LDAP server. This requirement can be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
This option is useful only when running mysqld on host machines having multiple CPUs, multiple cores, or both. When this option is enabled, and both --ndb-log-updated-only and --ndb-log-update-minimal are disabled, operations of different types are ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
The --dns-srv-name option takes precedence over the --host option if both are given. The --fido-register-factor option executes both the initiate and registration steps, which avoids the failure scenario described above and prevents having to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
The key steps in this startup process for the simplest possible GTID replication topology, consisting of one source and one replica, are as follows: If replication is already running, synchronize both servers by making them read-only. Restart both ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
SELECT supports explicit partition selection using the PARTITION clause with a list of partitions or subpartitions (or both) following the name of the table in a table_reference (see Section 15.2.13.2, “JOIN Clause”). Because MySQL also permits ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one. They have these comparative characteristics: ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If both compression and encryption are enabled, compression occurs before encryption. If both compression and encryption are enabled, compression occurs before encryption. Retrieve the keyring password like this: SELECT ... This section describes ...