PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.0/en/begin-end.html
Note Within all stored programs, the parser treats BEGIN [WORK] as the beginning of a BEGIN ... END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A ...
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 ...