PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
The current global and session time zone values can be retrieved like this: SELECT @@GLOBAL.time_zone, @@SESSION.time_zone; timezone values can be given in several formats, none of which are case-sensitive: As the value 'SYSTEM', indicating that the ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
You can select a target MySQL Server release to which you plan to upgrade, ranging from the MySQL Server 8.0.11 up to the MySQL Server release number that matches the current MySQL Shell release number. To identify such tables, execute this query: ... Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
The constructed tables in the UNION must contain the same number of columns, just as if you were using SELECT. VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, if a user can grant the SELECT and UPDATE privileges to regular accounts, then with SYSTEM_USER the user can also grant SELECT and UPDATE to system accounts. As of MySQL 8.0.16, MySQL incorporates the concept of user account ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... It enables authentication, role, SSL/TLS, ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. A SELECT never causes a flush of a bulk insert unless a normal insert occurs while it is loading. A SELECT operation performs a complete table scan: When a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
Suppose that a call to obtain a bookmark produces this value: mysql> SET @mark := audit_log_read_bookmark(); mysql> SELECT @mark; +-------------------------------------------------+ | @mark | +-------------------------------------------------+ | { ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
The first column shows the result of the SELECT using the Swedish/Finnish collating rule, which says that U-umlaut sorts with Y. The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The ...latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html
The SELECT and EXECUTE privileges on the Performance Schema is required to access the Performance Schema clone tables. mysql> SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current WHERE EVENT_NAME LIKE ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
If that is not feasible, a workaround is to use column aliases in the select list that return column names in the required lettercase. For example: SELECT TABLE_SCHEMA AS table_schema, TABLE_NAME AS table_name FROM INFORMATION_SCHEMA.TABLES WHERE ...