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/prepare.html
Repreparation does not occur if any of the following conditions are true: NULL is used as the actual parameter value. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
On the other hand, with SET, you can assign a variable's value using an expression, which is not true when you set a variable at server startup. Many MySQL programs have internal variables that can be set at runtime using the SET statement. See ...
https://dev.mysql.com/doc/refman/8.0/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
A value of 0 for Seconds_Behind_Source can usually be interpreted as meaning that the replica has caught up with the source, but there are some cases where this is not strictly true. The most common task when managing a replication process is to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The format of binary log encryption keys in the keyring is as follows: MySQLReplicationKey_{UUID}_{SEQ_NO} For example: MySQLReplicationKey_00508583-b5ce-11e8-a6a5-0010e0734796_1 {UUID} is the true UUID generated by the MySQL server (the value of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
(This is true even if both tables have the same number of columns.) Columns common to both versions of the table must be defined before any additional columns. Source and target tables for replication do not have to be identical. A table on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-floatvalues.html
This is true for operations that use floating-point values explicitly, or that use values that are converted to floating-point implicitly. With statement-based replication, values are converted from decimal to binary. Because conversions between ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
(See also Section 19.5.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and RAND(). Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
This remains true even if replica_parallel_workers or slave_parallel_workers has been changed to 0 before START REPLICA, and even if START REPLICA is used with UNTIL clauses. Inconsistencies in the sequence of transactions that have been executed ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
This is even true for statements affecting tables that use a nontransactional storage engine (such as MyISAM). In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You ...