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/connection-compression-control.html
Note X Protocol connections to a MySQL Server instance support compression from MySQL 8.0.19, but compression for X Protocol connections operates independently from the compression for classic MySQL protocol connections described here, and is ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
Note Prior to MySQL 8.0.27, auth_option defines the sole method by which an account authenticates. Note Clauses for random password generation apply only to accounts that use an authentication plugin that stores credentials internally to MySQL. Note ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
Note There is no need to use this mechanism to create the root superuser, which is created by default with the password set by either one of the mechanisms discussed in the descriptions for MYSQL_ROOT_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD, unless ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
prio The event priority, to indicate a system, error, warning, or note/information event. Event Type Numeric Priority System event 0 Error event 1 Warning event 2 Note/information event 3 The prio value is numeric. Error events intended for the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
prio The event priority, to indicate an error, warning, or note/information event. Event Type Priority Symbol Numeric Priority Error event ERROR 1 Warning event WARNING 2 Note/information event INFORMATION 3 There is also a message priority of ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-syslog.html
Note For MySQL 8.0 configuration, you must enable error logging to the system log explicitly. On Windows, error messages written to the Event Log within the Application log have these characteristics: Entries marked as Error, Warning, and Note are ... It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Note You can issue event-manipulation statements when event_scheduler is set to DISABLED. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
Note For a multiple-row insert, LAST_INSERT_ID() and mysql_insert_id() actually return the AUTO_INCREMENT key from the first of the inserted rows. To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The following grammar rules define expression syntax in MySQL. For additional information about some of the expression terms, see Expression Term Notes. Expression Term ...