PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
On Windows, the editing key sequences are the same as supported for command editing in console windows. On Unix, the key sequences depend on the input library used to build mysql (for example, the libedit or readline library). To change the set of ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The transaction_id is a sequence number determined by the order in which the transaction was ...This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
From MySQL 8.0, this repository is created by default as an InnoDB table named mysql.slave_relay_log_info. GTID auto-positioning means the replica can reliably identify and retrieve missing transactions, even if there are gaps in the sequence of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings are sequences of bytes and the numeric values of those bytes determine comparison and sort order. The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and ... This section describes how the binary collation for binary strings compares to _bin collations for nonbinary ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
*/ C-style comment syntax, with a + character following the /* comment opening sequence. Consider this sequence of statements: SET @saved_val = @@SESSION.var_name; SET @@SESSION.var_name = value; SELECT ... SET @@SESSION.var_name = @saved_val; The ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html
MySQL Server supports a variant of the -- comment style; the -- start-comment sequence is accepted as such, but must be followed by a whitespace character such as a space or newline. To keep this from happening, MySQL requires a whitespace character ... Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
If an incoming sequence is illegal, an error or warning is returned. If an illegal sequence is used in CONVERT(), an error is returned. The character set determines the length of a sequence using the first 1 or 2 bytes. In MySQL, the gb18030 ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those statements. Note A dump made using PowerShell on Windows with output ...