PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-sets.html
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. For both, ñ (n-tilde) is a ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/mysql-command-options.html
The --dns-srv-name option takes precedence over the --host option if both are given. The --dns-srv-name option takes precedence over the --host option if both are given. For example, to explicitly disable local data loading except for files located ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
Quoting of the user or host value (or both values) is necessary only in certain cases; for information about this, see the description of --include-user. --users is incompatible with the --flush-privileges option, and an error occurs if you try to ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/audit-log-component-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 ...
https://dev.mysql.com/doc/refman/9.7/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 ... Important The audit_log ...