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/binary-log-mixed.html
Note A warning is generated if you try to execute a statement using statement-based logging that should be written using row-based logging. When running in MIXED logging format, the server automatically switches from statement-based to row-based ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this section. You can select the binary logging format explicitly by starting the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The term “binary log file” generally denotes an individual numbered file containing database events. The term “binary log” collectively denotes the set of numbered binary log files plus the index file. Note that the binary log format differs ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Note UUID_TO_BIN() takes a flag that causes some bit rearrangement in the resulting binary UUID value. Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
Note In the name sha256_password, “sha256” refers to the 256-bit digest length the plugin uses for encryption. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: ...
https://dev.mysql.com/doc/refman/8.0/en/case.html
Note There is also a CASE operator, which differs from the CASE statement described here. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
Note Global replication filters cannot be set on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. Filters set using ...
https://dev.mysql.com/doc/refman/8.0/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...