PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
The warning is shown both in the client (in the output of SHOW WARNINGS) and through the mysqld error log. A given storage engine can support either or both logging formats. Type binlog_format SLC RLC Error / Warning Logged as * * No No Error: ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
Binary log transaction compression therefore saves storage space both on the originator of the transaction and on the recipient (and for their backups), and saves network bandwidth when the transactions are sent between server instances. Setting ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
But if they have different collations, should the comparison use the collation of x, or of 'Y'? Both x and 'Y' have collations, so which collation takes precedence? A mix of collations may also occur in contexts other than comparison. If both sides ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Some cp932 characters have two different code points, both of which convert to the same Unicode code point. (See http://support.microsoft.com/kb/170559/EN-US/.) The conversion rule works like this: If the character is in both JIS X 0208 and NEC ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
The remaining properties apply globally to all accounts named in the statement, so for both accounts: Connections must be made using a valid X.509 certificate. CREATE USER Authentication Options An account name may be followed by an auth_option ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
How does MySQL represent the Yen (¥) sign? A problem arises because some versions of Japanese character sets (both sjis and euc) treat 5C as a reverse solidus (\, also known as a backslash), whereas others treat it as a yen sign (¥). mysql> CREATE ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
To use IPv6 addresses, the operating system on the server host and the MySQL Server instance must both be configured to support IPv6. If a host name specified as the Group Replication local address for a server instance resolves to both an IPv4 and ... As of MySQL 8.0.14, Group Replication group members can use IPv6 addresses as an alternative to IPv4 addresses for communications within the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
Suppose that column c1 occurs only in table t1, c2 only in t2, and c in both t1 and t2. Suppose that column c1 occurs only in table db1.t, c2 only in db2.t, and c in both db1.t and db2.t. An unqualified name is permitted in contexts where ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
The operations by sessions 2 and 3 both result in a duplicate-key error and they both request a shared lock for the row. The operations by sessions 2 and 3 both result in a duplicate-key error and they both request a shared lock for the row. A ...